Error occurred at recursive SQL level 1 ORA-01003

2406
Views
1
Answers

I am getting the following error when we try to execute a procedure through .net application (web service).

Exception: DBD, ORA-00604: error occurred at recursive SQL level 1
ORA
-01003: no statement parsed
State: N/A

what could be the problem? Please suggest.

edit | flag
William Patrick
Asked on: Oct 19, 2011 at 11:19PM

1 Answers

72
9
72

Try these steps consecutively till you get it working.

  1. Normally it can be a syntax error.Check syntax if you are you using dynamic sql.
  2. Check the name of tables, columns and the structure of the tables involved in the procedure.
  3. One table or one or more columns the some tables are missing, maybe privileges.
  4. Create a new version of procedure to extract the sql statement, compile and run new version and test the sql statement generated by the procedure.
  5. Drop the procedure and recreate it. This should work if step 1-4 are correct.

Cheers!!

edit | flag
Gokul A
Answered on: Oct 19, 2011 at 11:27PM

Post your Answer

Search

Welcome to Ask Amoeba!
This is 100% free and interactive site for sharing professional Questions and Answers, Opensource projects, Interview questions.
Learners, beginners, Experts stop and share your knowledge and ideas!

Browse Categories

Browse Tags