Home » RDBMS Server » Server Administration » What does this LEVEL 3 MEANS IN (ORA-00604: error occurred at recursive SQL level 3)
What does this LEVEL 3 MEANS IN (ORA-00604: error occurred at recursive SQL level 3) [message #266312] Mon, 10 September 2007 08:35 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No; I can't, I think I explain it clearly with an example.
What don't you understand?

Regards
Michel
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 Go to previous messageGo to next message
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.
icon7.gif  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 Go to previous messageGo to next message
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

Thanks & regards
Re: What does this LEVEL 3 MEANS IN (ORA-00604: error occurred at recursive SQL level 3) [message #267523 is a reply to message #267518] Thu, 13 September 2007 10:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You search for a link? I don't know any.

Regards
Michel

[Updated on: Thu, 13 September 2007 10:57]

Report message to a moderator

icon2.gif  Re: What does this LEVEL 3 MEANS IN (ORA-00604: error occurred at recursive SQL level 3) [message #267530 is a reply to message #267523] Thu, 13 September 2007 11:08 Go to previous message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hi Michel,

Its fine for all

thanks for the guiding me.

Regards
Aslam Khalife
Previous Topic: Database can't be started (merged)
Next Topic: instant client
Goto Forum:
  


Current Time: Sat Nov 09 14:47:21 CST 2024