My Oracle Support Banner

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 JULY 20, 2021

Applies to:

Oracle SQL Developer - Version 18.1 and later
Information 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.


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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.