:

ORA-06508: PL\SQL:could not find the program unit being called

I was installing the Java and the NCOMP libraries into the Oracle software home and into the DB, version 10.2.0.4. and I got the following error:

ORA-04065: not executed, altered or dropped stored procedure “PUBLIC.DBMS_OUTPUT”
ORA-06508: PL\SQL:could not find the program unit being called: “PUBLIC.DBMS_OUTPUT”

In order to resolve this issue I ran the following:

shutdown immediate
startup upgrade
@?/rdbms/admin/utlirp
shutdown immediate
startup
@?/rdbms/admin/utlrp

For more information regarding this, please see Metalink note 370137.1.

Make sure that when you are executing the scripts and using the @?/ command that your Oracle home is set appropriately. It is probably better to explicitly call the script from the Oracle Home that you want to use.

Like it, share it...

Category: PL/SQL


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *