Search code examples
oracle-databaseplsql

Trouble compiling or dropping an Oracle package


I was trying to compile a PL/SQL package and I got the following error:

ORA-04043: object SYS_PLSQL_77721_489_1 does not exist

After this, I can no longer recompile or drop the package.

Do you have any suggestions?


Solution

  • if you have access to support, this looks like bug #3744836. A similar bug is described here, related to pipelined functions and synonyms.