| meraj |
Posted: Sep 25, 2007 08:41:03 AM |
Total Post: 31
Joined: Sep, 2006
|
Hi All,
Can anyone explain me RECURSIVE SQL ERROR in detail.
Thanks in Advance...
Mehraz |
|
|
 parthokonar |
| Posted: Sep 25, 2007 01:20:56 PM |  |
|
Total Post: 27
Joined: Sep, 2007
|
Actually it is an ORA-00604:
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.
|
|
|
|
|
| Ramesh Joyisa |
| Posted: Sep 25, 2007 11:16:14 PM | |
|
Total Post: 226
Joined: Aug, 2007
|
It might be ORA-00036
maximum number of recursive SQL levels (string) exceeded
Cause
An attempt was made to go more than the specified number of recursive SQL levels.
Action
Remove the recursive SQL, possibly a recursive trigger.
|
|
|
|
|
| krish |
| Posted: Oct 04, 2007 02:26:03 PM | |
|
Total Post: 4
Joined: May, 2007
|
When you issue a SQL statement, the database must determine many things before it can even start executing that SQL statement. If you query a table, do you have permissions to access that table? Does that table even exist? Which tablespace holds that table? Oracle needs answers to these questions and more.
if Oracle needs to find out if a table exists, Oracle will issue a SQL statement against the Data Dictionary to answer that question. This is similar to you querying DBA_TABLES to determine if the table exists. All of the SQL that Oracle issues behind the scenes on your behalf is called "recursive SQL." Some of the recursive SQL statements will require other questions to be asked, which spawns a new level of recursive SQL.
If Oracle finds a problem with your SQL statement, like the table does not exist, then Oracle will raise an error (ORA-00942). If Oracle does not find any problem, then your SQL statement will be executed
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 02:57:02 PM | |
|
Total Post: 416
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
