Exception – ORA-00604: error occurred at recursive SQL level 1 ORA-01003: no statement parsed

In my application data were collected from database (Oracle) using web services that called stored procedures. One of the stored procedure had SELECT defined similar to the one below:

WITH sth1 as 
(
	SELECT ...
),
sth2 as 
(
	SELECT ...
)
SELECT ...

This construction was the reason why in my application I was getting the following exception while invoking that web service:

Exception – ORA-00604: error occurred at recursive SQL level 1 ORA-01003: no statement parsed

Solution

The simplest solution for that is to create tables representing sth1 and sth2 created with WITH clause. Then instead of using WITH truncate those tables and fill with data. Finally query against them in the main SELECT.

Updated, 2008-10-22
It turns out if you use a regular table, you may have some problems with multiple calls to the stored procedure – the second call could overwrite the first call’s data with a second call to truncate.
Therefore use either:

 Exception   ORA 00604: error occurred at recursive SQL level 1 ORA 01003: no statement parsed

1 Response to “Exception – ORA-00604: error occurred at recursive SQL level 1 ORA-01003: no statement parsed”


  • I installed Ora-10g first, then developer 10g in my computer under windows 7 operating system. After installing Developer-10g, I update Tnsnames.ora file and try to connect remote database and I am getting following error messages and I could not connect remote database using developer -10. Can I get some suggestion for possible solution of the above problem, Thanks.

    1. Ora-00604– Error occurred recursive SQL level 1.

    2. Ora-01009– missing mandatory parameter.

Leave a Reply