OraFAQ Forum: Server Administration » ORA-23324: error ORA-00604: error occurred at recursive SQL level

Home » RDBMS Server » Server Administration » ORA-23324: error ORA-00604: error occurred at recursive SQL level

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

ORA-23324: error ORA-00604: error occurred at recursive SQL level [message #61097]

Mon, 29 March 2004 19:43

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

Report message to a moderator

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

Raja
Messages: 57
Registered: March 2000

Member

Loop is a key word in PL/SQL. So may be this error.

Report message to a moderator

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

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.

Report message to a moderator

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

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.

Report message to a moderator

ORA-00604: error occurred at recursive SQL level [message #62031 is a reply to message #61099]

Mon, 21 June 2004 03:05

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

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	How to increase the user connections.
Next Topic:	Urgent !!!!TNS-03506: Failed to create address binding

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 03:45:48 CST 2025