CODEWITHSUNDEEP
oracle-databaseplsql
Ariod
Ariod

Reputation: 5851

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?

Upvotes: 2

Views: 16975

Answers (6)

Panagiotis Piperopoulos
Panagiotis Piperopoulos

Reputation: 534

In my case I found the object SYS_PLSQL_72104C9A_35_1 that was supposed to be missing, using PL/SQL Developer. I suppose SQL Developer or any other IDE would work as well. The object appeared under the types tree in the object explorer. I fact more than one SYS_PLSQL_xxx existed. I droped all these types and then I was able to compile my package. So you must somehow find these mysterius invalid types and drop them.

Upvotes: 0

Raj Gaurav
Raj Gaurav

Reputation: 21

Try to create the types as mentioned in the error message to resolve error while dropping or compiling packages. Error :ORA-04043: object SYS_PLSQL_ B1A0D561_1132_1 does not exist Resolution : CREATE TYPE SYS_PLSQL_B1A0D561_1132_1;

After that one more error came which reads Error :ORA-04043: object SYS_PLSQL_B1A0D561_1242_1 does not exist Resolution :CREATE TYPE SYS_PLSQL_B1A0D561_1242_1;

and issues resolved.

Upvotes: 1

Daniel Martinho Bisleri
Daniel Martinho Bisleri

Reputation: 21

create or replace type SYS_PLSQL_77721_489_1 as object

for all erros when you drop

try drop again and again and create type for all erros...

Upvotes: 0

APC
APC

Reputation: 146179

One confirmed cause of this problem is the use of pipelined functions with PL/SQL types. It is a bug, and so ought to fixed in more recent or fully patched versions of Oracle. A workaround would be to use SQL types instead (i.e. create type whatever as object ... ).

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

Upvotes: 1

FerranB
FerranB

Reputation: 36767

Try to do this:

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

I've had exactly the same problem and works. Sorry @Vicent but the link you provide does not solve the problem.

Upvotes: 8

Vincent Malgrat
Vincent Malgrat

Reputation: 67722

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

Upvotes: 2

Related Questions