OraFAQ Forum: Server Administration » What does this LEVEL 3 MEANS IN (ORA-00604: error occurred at recursive SQL level 3)

Home » RDBMS Server » Server Administration » What does this LEVEL 3 MEANS IN (ORA-00604: error occurred at recursive SQL level 3)

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

What does this LEVEL 3 MEANS IN (ORA-00604: error occurred at recursive SQL level 3) [message #266312]

Mon, 10 September 2007 08:35

aslamkhalife
Messages: 42
Registered: July 2007
Location: India

Member

Hi

I have received and error while working on Oracle 10g Release 2

ORA-00604: error occurred at recursive SQL level 3

I am unable to understand LEVEL 3 what does it means

Please any could explain me this LEVEL 3.

Thanks & Regards

Report message to a moderator

Re: What does this LEVEL 3 MEANS IN (ORA-00604: error occurred at recursive SQL level 3) [message #266317 is a reply to message #266312]

Mon, 10 September 2007 08:54

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

Senior Member
Account Moderator

It means the error occurs at the fourth level of analysis/execution below your direct query.

For instance, you call a procedure (level 0) that call SQL (level 1) that triggers a trigger (level 2) that executes a SQL (level 3)...

Regards
Michel

Report message to a moderator

Re: What does this LEVEL 3 MEANS IN (ORA-00604: error occurred at recursive SQL level 3) [message #266319 is a reply to message #266317]

Mon, 10 September 2007 09:00

aslamkhalife
Messages: 42
Registered: July 2007
Location: India

Member

Hi

Could you be some more specific in this or please can you tell me the link regarding this LEVELS.

And Thanks for such a quick reply.

Waiting for you Reply

Thanks & Regards

Report message to a moderator

Re: What does this LEVEL 3 MEANS IN (ORA-00604: error occurred at recursive SQL level 3) [message #266322 is a reply to message #266319]

Mon, 10 September 2007 09:19

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

Senior Member
Account Moderator

No; I can't, I think I explain it clearly with an example.
What don't you understand?

Regards
Michel

Report message to a moderator

Re: What does this LEVEL 3 MEANS IN (ORA-00604: error occurred at recursive SQL level 3) [message #266385 is a reply to message #266319]

Mon, 10 September 2007 12:28

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

List your procedure, the tables involved and a list of all triggers defined on all tables in the procedure.

Report message to a moderator

Re: What does this LEVEL 3 MEANS IN (ORA-00604: error occurred at recursive SQL level 3) [message #267518 is a reply to message #266322]

Thu, 13 September 2007 10:49

aslamkhalife
Messages: 42
Registered: July 2007
Location: India

Member

Hi Michel,

I understood bout the LEVEL of SQL, the only thing was i wanted

to know how can i know more bout this, as of am new to Oracle

world Razz