 |
|
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.
Oracle MOSC offers exceptional information regarding ORA-00604 in
regards to the generate preventive maintenance work orders within 11.5.9 on all
platforms. It is explained that ORA-00604 occurs in Oracle
Enterprise Asset Management, within the Generate Work Orders program as part of
the bug 42325313. In version 115.10.1159.5, this issue of ORA-00604 is
filed within PMEngine.java .
In order to fully resolve ORA-00604 , use the following steps provided to
properly apply Patch 4232513 by MOSC:
1. Download and read the readme and pre-requisites
2. Apply Patch 4232513, but in a test environment
3. Confirm these file versions:
- PMEngine.java 115.10.1159.5
4. try re-testing
5. Upon resolution, migrate the solution to the other environments as you see
appropriate
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écursif 1
ORA-04068: état de packages existant rejetés
ORA-04063: package body "SYS.DBMS_CDC_PUBLISH" a des erreurs
ORA-06508: PL/SQL : Impossible de trouver unité de programme appelé
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
|
