Re: Where is the DBMS_STANDARD ? ORA-6554

Thanks Sybrand,

Your advice is very helpful. The problem is fixed now......:-)

Thanks again...

HV.

Sybrand Bakker wrote:

> 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 - 14:23:44 CST