OraFAQ Forum: SQL & PL/SQL » ORA-00604 and ORA-01003

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00604 and ORA-01003

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00604 and ORA-01003 [message #537470]

Wed, 28 December 2011 14:18

ora1980
Messages: 251
Registered: May 2008

Senior Member

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 ?

Report message to a moderator

Re: ORA-00604 and ORA-01003 [message #537471 is a reply to message #537470]

Wed, 28 December 2011 14:25

ora1980
Messages: 251
Registered: May 2008

Senior Member

version

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

Report message to a moderator

Re: ORA-00604 and ORA-01003 [message #537474 is a reply to message #537470]

Wed, 28 December 2011 14:50

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

ORA-01003 means if the column name is wrong or the view name is wrong

This is not correct.

No one is able to debug code he does not see.

Regards
Michel

Report message to a moderator

Re: ORA-00604 and ORA-01003 [message #537478 is a reply to message #537474]

Wed, 28 December 2011 15:30

ora1980
Messages: 251
Registered: May 2008

Senior Member

i agree, my question is vague, just wondering if anyone faced this kind of issue before

its puzzling why it works for me when i call it in an anonymous block from sqlplus, but doesn't work from java

i closed the ref cursor before opening it and now informed them to test again

Report message to a moderator