ORA-00604 and ORA-01003
I have a stored procedure which constructs a sql statement dynamically from a view, A user is testing my program from Java, And is getting the following error
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01003: no statement parsed
I try calling the procedure from sqlplus by declaring host variable for ref cursor and it works fine for me, The user is logging in the same schema where my procedure is,
what could be the issue ?
ORA-01003 means if the column name is wrong or the view name is wrong, but i do not see anything like that, In my code, do i have to close the refcursor before opening it ?