Home » RDBMS Server » Server Administration » ORA-23324: error ORA-00604: error occurred at recursive SQL level
ORA-23324: error ORA-00604: error occurred at recursive SQL level [message #61097] Mon, 29 March 2004 19:43 Go to next message
Sachin
Messages: 52
Registered: May 2001
Member
Hi,

I am working on Oracle 9i on AIX 5.1 and getting error when using the follwing sql commands

SQL> select count(*) from deftran;

COUNT(*)
----------
7

1 row selected.

SQL> select dblink, count(*) from deftrandest group by dblink order by dblink;

DBLINK COUNT(*)
--------------- ----------
LOOP 7

1 row selected.

SQL> select count(*) from deferror;

COUNT(*)
----------
0

1 row selected.

SQL>
SQL>
SQL> rem try to execute the calls
SQL> execute dbms_defer_sys.execute('LOOP');
BEGIN dbms_defer_sys.execute('LOOP'); END;

*
ERROR at line 1:
ORA-23324: error ORA-00604: error occurred at recursive SQL level
ORA-02063: preceding line from LOOP, while creating deferror entry at "LOOP" with error -604
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1716
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1758
ORA-06512: at line 1

I am not able to find out what is causing this error? Could anyone of Oracle Gurus please suggest me on that?

Please help me.

Thanks,

Sachin
Re: ORA-23324: error ORA-00604: error occurred at recursive SQL level [message #61099 is a reply to message #61097] Mon, 29 March 2004 20:46 Go to previous messageGo to next message
Raja
Messages: 57
Registered: March 2000
Member
Loop is a key word in PL/SQL. So may be this error.
Re: ORA-23324: error ORA-00604: error occurred at recursive SQL level [message #61115 is a reply to message #61099] Tue, 30 March 2004 02:51 Go to previous messageGo to next message
Ken Jones
Messages: 70
Registered: January 2004
Member
Hi,

As soon as you see this error you either contact Oracle Support or go to metalink and put the stack trace into the special ORA-006** tool.

No other options. Serious error - database may be corrupt/damaged.

Ken.
Re: ORA-23324: error ORA-00604: error occurred at recursive SQL level [message #61116 is a reply to message #61099] Tue, 30 March 2004 02:52 Go to previous messageGo to next message
Ken Jones
Messages: 70
Registered: January 2004
Member
Hi,

As soon as you see this error(error ORA-00604: error occurred at recursive SQL level) you either contact Oracle Support or go to Metalink and put the stack trace into the special ORA-006** tool.

No other options. Serious error - database may be corrupt/damaged.

Ken.
ORA-00604: error occurred at recursive SQL level [message #62031 is a reply to message #61099] Mon, 21 June 2004 03:05 Go to previous messageGo to next message
hari prasad
Messages: 3
Registered: June 2002
Junior Member
sql> select sys.date from dual;

While executing the above Query, the following error occured.

ORA-00604 "Error Occured at recurrsive Sql String"

Kindly Suggest
Hari Prasad
Re: ORA-23324: error ORA-00604: error occurred at recursive SQL level [message #62391 is a reply to message #61115] Mon, 19 July 2004 14:51 Go to previous message
Dan
Messages: 61
Registered: February 2000
Member
Your table SDO_GEOM_METADATA_TABLE (part of Oracle Spatial) not present in the DB or is corrupted.

FIX -
Run the script catmd.sql (located in $ORACLE_HOME/md/admin dir).

The catmd.sql script is the script that loads all objects needed by Oracle spatial in the
database.
Previous Topic: How to increase the user connections.
Next Topic: Urgent !!!!TNS-03506: Failed to create address binding
Goto Forum:
  


Current Time: Fri Mar 29 01:54:59 CDT 2024