What is the way to solve SQL Error: ORA-00604: error occurred at recursive SQL level 1 ?

Question

I got the error when tried to drop the table:

SQL Error: ORA-00604: error occurred at recursive SQL level 2 

ORA-01422: exact fetch returns more than requested number of rows 

00604. 00000 - "error occurred at recursive SQL level %s" 

*Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables). 

*Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support.

Answer 1

I think there is this error in your code:

exact fetch returns more than requested number of rows

It shows that Oracle expected one row but It got so many rows. So, only a dual table has that feature of returning one row.

Further I recalled, I did changes in the dual table and when I executed the dual table. Then got multiple rows.

Therefore, I truncated dual table and inserted only rows with X value. After this things started working fine.

If you want to get more insights into SQL, checkout this SQL Course from Intellipaat.