OraFAQ Forum: SQL & PL/SQL » ORA-00604: error occurred at recursive SQL level (6 Merged)

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00604: error occurred at recursive SQL level (6 Merged) (Oracle, 10g, Windows Xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00604: error occurred at recursive SQL level (6 Merged) [message #499340]

Mon, 14 March 2011 10:42

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Hi,

I am using Oracle 10g Database as back end and Developer 6i as front end.

I have a procedure which is called upon SAVE. Means before COMMIT;

This procedure holds few updates and delete statments.

This prcedure is throughing sql error as follows:

ORA-00604: error occurred at recursive SQL level

The error occur when an delete statment is issued which as follows:

DELETE FROM DUMMY_TAB001;

I issue the same statement from SQL it is running fine. But when my from runs on this delete statment encounter it through the above oracle error ORA-00604.

Regards,
Azo Khan

Report message to a moderator

Re: ORA-00604: error occurred at recursive SQL level [message #499344 is a reply to message #499340]

Mon, 14 March 2011 10:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

privileges acquired via ROLE do NOT apply within named PL/SQL procedures.

I suspect that current USER is not owner of DUMMY_TAB001

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: ORA-00604: error occurred at recursive SQL level [message #499352 is a reply to message #499340]

Mon, 14 March 2011 10:49

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

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.

Report message to a moderator

Re: ORA-00604: error occurred at recursive SQL level [message #499452 is a reply to message #499344]

Mon, 14 March 2011 23:33

azamkhan
Messages: 557
Registered: August 2005

Senior Member

I have recreated the public synonym again and also granted all privileves to PUBLIC ON DUMYY_TAB001.

So there is no chance of privileges not granted.

And Yes Dummy_Tab001 is not a table of my current user but this error is also comming on the user to whom this object belongs.

Report message to a moderator

Re: ORA-00604: error occurred at recursive SQL level [message #499454 is a reply to message #499452]

Mon, 14 March 2011 23:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

How can we reproduce what you report?

You have a mystery & we have no clues.

Sad

Report message to a moderator

Re: ORA-00604: error occurred at recursive SQL level [message #499471 is a reply to message #499454]

Tue, 15 March 2011 00:17

azamkhan
Messages: 557
Registered: August 2005

Senior Member

The problem is solved... Surprised

Report message to a moderator

Re: ORA-00604: error occurred at recursive SQL level [message #499475 is a reply to message #499471]

Tue, 15 March 2011 00:24

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And the error was?

Regards
Michel

Report message to a moderator

Re: ORA-00604: error occurred at recursive SQL level [message #499477 is a reply to message #499475]

Tue, 15 March 2011 00:29

azamkhan
Messages: 557
Registered: August 2005

Senior Member

That is the good part... I still cant find what was the problem... I simply just tried to updated a record that does not run that particular procedure that issue the delete statment for the table. Then save it. Then again I try to perform the fully action that involve that delete statment that was causing the ERROR and now it is not raising any error...

Still have no idea what was causing this problem

Report message to a moderator

Previous Topic:	UTL_TCP
Next Topic:	DBMS_LOB.SUBSTR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 09:40:23 CDT 2024