ORA-00604 Error Occurs at Recursive SQL level While Creating Package/Procedure using SQL Developer on Upgraded 12c Database
(Doc ID 2476156.1)
Last updated on FEBRUARY 13, 2023
Applies to:
Oracle SQL Developer - Version 18.1 and laterInformation in this document applies to any platform.
This issue is seen on the upgraded/patched 12c database only while using SQL Developer, but works fine with SQL*Plus.
Symptoms
After patching existing 12c database (for example, patch to 12.2.0.1.181016), the following exception is seen while connecting and creating a Package/Procedure from SQL Developer:
CREATE OR REPLACE
PACKAGE PACKAGE1 AS
END PACKAGE1;
/
Error starting at line: 1 of the command:
CREATE OR REPLACE
PACKAGE PACKAGE1 AS
END PACKAGE1;
Error report -
ORA-00604: a recursive SQL level 1 error has occurred
ORA-00904: "DECL_OBJ #": invalid identifier
00604. 00000 - "error occurred at recursive SQL level% s"
* 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.
PACKAGE PACKAGE1 AS
END PACKAGE1;
/
Error starting at line: 1 of the command:
CREATE OR REPLACE
PACKAGE PACKAGE1 AS
END PACKAGE1;
Error report -
ORA-00604: a recursive SQL level 1 error has occurred
ORA-00904: "DECL_OBJ #": invalid identifier
00604. 00000 - "error occurred at recursive SQL level% s"
* 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.
However, if run this same command in SQL*Plus directly on the server, then it works correctly.
Changes
Database 12c is patched or upgraded
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |