oracle

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 …