Oracle Error - ORA-00604 error occurred at recursive SQL level 1

[Navratan]

Hi All,

when i am trying to insert a record into table then i am getting above error. what to do to solve this type of problem. if any body knows the solution for this problem please send me detail to my email id : aliment@realnet.zo.sz or navratanc@yahoo.com

Error Message:

ORA-00604 error occured at recursive SQL Level 1


Regards
Aliment

[Sanjay Kumar Suri]

The error means:

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.


Check this link as well:

http://www.databasejournal.com/features/oracle/article.php/10893_3308031_2

sks

[Volker Borowski]

Hi,

check the alert log. There have been various errors that show the ORA-60x as a follow up fault. Sometimes you simply have extent or tablespace overflows which have the 600 as a follow up error.

What release do you use ?
Volker

[Indira Aramandla]

Hi,

May be it is a privilege issue, or constrainy issue. What other errors were reported after the error, For example

ORA-604: error occured at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_SOURCE1) violated or
ORA-00001: unique constraint (SYS.I_VIEW1) violated

Or
ORA-604: error occured at recursive SQL level 1
ORA-01031: insufficient privileges

Please provide the steps you have followed. Also provide the version of oracle Database

You can check the alertsid.log for more details.


Indira A

[Yogeeraj_1]

hi,

also let us know the tool that you are using so that we try to help you debug this error.

regards
Yogeeraj