Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Navratan
Occasional Visitor

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

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
4 REPLIES
Sanjay Kumar Suri
Honored Contributor

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

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
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Volker Borowski
Honored Contributor

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

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
Honored Contributor

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

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
Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

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

hi,

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

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)