topic Re: Oracle Error - ORA-00604 error occurred at recursive SQL level 1 in Operating System - HP-UX

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

Navratan — Sat, 26 Jun 2004 10:42:01 GMT

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

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

Sanjay Kumar Suri — Sun, 27 Jun 2004 01:14:27 GMT

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

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

Volker Borowski — Sun, 27 Jun 2004 03:43:03 GMT

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

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

Indira Aramandla — Sun, 27 Jun 2004 20:12:17 GMT

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

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

Yogeeraj_1 — Mon, 28 Jun 2004 00:01:17 GMT

hi,

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

regards
Yogeeraj