Re: Where is the DBMS_STANDARD ? ORA-6554

I would recommend running
$ORACLE_HOME\RDBMS\ADMIN\catproc.sql again, using svrmgrl (do not use sqlplus) connected as internal.
DBMS_STANDRAD is the CENTRAL package, it is definitely created by catproc, and more may have gone wrong in your case.

Hth,

Sybrand Bakker, Oracle DBA

Huy Vu wrote:

> Hi all,
>
> I'm able to run the sqlplus system/passwd_at_test command but It gives me
> the error ORA-6554
>
> $ oerr ora 6554
> 06554, 00000, "package DBMS_STANDARD must be created before using
> PL/SQL"
> // *Cause: The DBMS specific extensions to PL/SQL's package
> "STANDARD"
> // are in package "DBMS_STANDARD". This package must be
> // created before using PL/SQL.
> // *Action: Create package "DBMS_STANDARD". The source for this
> // PL/SQL stored package is provided with the distribution.
>
> Does someone know where is it ?
>
> Thank you in advance for any help !
>
> H.V

Received on Sat Feb 27 1999 - 02:38:14 CST