Clever Geek Handbook

Troubleshoot or remove 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 that, I can no longer recompile or remove the package.

Do you have any suggestions?

+2


source to share


3 answers


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



+2


source


Try this:

DROP TYPE SYS_PLSQL_77721_489_1;
DROP TYPE SYS_PLSQL_77721_DUMMY_1;
DROP PACKAGE BODY xxxx;
DROP PACKAGE xxx;


I had exactly the same problem and it works. Sorry @Vicent, but the link you provide doesn't solve the problem.

+6


source


One of the confirmed causes of this problem is the use of pipelined functions with PL / SQL types. This is a bug and therefore should be fixed in a later or fully fixed version of Oracle. A workaround would be to use SQL types instead of (i.e. create type whatever as object ...

).

If this does not apply in your situation, please edit your question to include more details.

+1


source






More articles:


All Articles