Tuesday, February 7, 2012

ORA-06554: package DBMS_STANDARD must be created before using PL/SQL


in the day starting  i was trying to  execute  procedures then it  given a error ORA-6554  error
.

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.

i have tried to  execute  dbms_standard package provided by the oracle .  even then also i faced same
problem.then i  opened database in upgrade mode and executed dbms_standard package. my problem was solved





No comments: