8 Replies Latest reply on Aug 26, 2014 3:19 AM by K Cannell

    DROP gives   SQL Error: ... ORA-04068: existing state of packages has been discarded ORA-04065: not executed, altered or dropped stored procedure "SYS.DICTIONARY_OBJ_NAME"

    K Cannell

      I am gettign this error when I attempt to drop objects in a SQL Developer .sql windows:

       

      DROP TABLE <any table>

      Error report -

      SQL Error: ORA-00604: error occurred at recursive SQL level 1

      ORA-04068: existing state of packages has been discarded

      ORA-04065: not executed, altered or dropped stored procedure "SYS.DICTIONARY_OBJ_NAME"

      ORA-06508: PL/SQL: could not find program unit being called: "SYS.DICTIONARY_OBJ_NAME"

      ORA-06512: at line 2

      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.

       

      This occurs only on one databae, in any schema in that database.  Seems to occur on DROP of any object,

      and on CREATE OR REPLACE commands.

       

      This is a new error - I am working with the offshore, ticket-oriented DBAs to figure out what has changed in this DB.

      Any suggestions?  Otherwise this could take a long time ...

       

      Thank you,

      Karen