ORA-00604: error occurred at recursive SQL level string tips

Home
E-mail Us
Oracle Articles
New Oracle Articles

Oracle Training
Oracle Tips
Oracle Forum
Class Catalog

Remote DBA
Oracle Tuning
Emergency 911
RAC Support
Apps Support
Analysis
Design
Implementation
Oracle Support

SQL Tuning
Security
Oracle UNIX
Oracle Linux
Monitoring
Remote support
Remote plans
Remote services
Application Server
Applications
Oracle Forms
Oracle Portal
App Upgrades
SQL Server
Oracle Concepts
Software Support
Remote Support
Development
Implementation

Consulting Staff
Consulting Prices
Help Wanted!

Oracle Posters
Oracle Books
Oracle Scripts
Ion
Excel-DB

Don Burleson Blog

ORA-00604: error occurred at recursive SQL level string tips

Oracle Error Tips by Burleson Consulting

Oracle docs note this about ORA-00604:

ORA-00604: error occurred at recursive SQL level string

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.

Many users of the new Oracle 11i find themselves being confronted by ORA-00604.

On this forum, a user finds ORA-00604 after attempting to run a newly created table using select*from cdc; The message they are receiving is:

ORA-00604: Une erreur s'est produite au niveau SQL r?ursif 1
ORA-04068: ?at de packages existant rejet?
ORA-04063: package body "SYS.DBMS_CDC_PUBLISH" a des erreurs
ORA-06508: PL/SQL : Impossible de trouver unit?de programme appel?br> ORA-06512: ?ligne 3

They are wondering how to get rid of ORA-00604.

The user found that to resolve ORA-00604, they needed to try re-compiling their DBMS_CDC_PUBLISH package using SYS. Running this repeatedly until invalid packages no longer show, should clear up any issues throwing ORA-00604. For more information in this process, you can refer to this article:

http://www.dba-oracle.com/t_recompile_reco...lid_objects.htm

��