Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: package STANDARD?
Hi;
In your sys account there is a standard package that maybe invalid. you need to recompile.
select object_name,object_type from dba_objects where status ='INVALID';
recompile all the packages, and package bodies to ensure everything is running properly
Connor McDonald wrote:
> Diego Peroni wrote:
> >
> > I'm trying to create my procedures or packages.
> > When i try to compile it Oracle tells me :
> >
> > error 06553 PLS-00213 PACKAGE STANDARD NOT ACCESSIBILE
> > (Make sure that package STANDARD is avaible in the current Oracle
> > database, then retry the operation)
> >
> > I'm logged as Internal/IOracle, sys, ... it's the same .... WHY???
> >
> > Thanks!
> > Diego Peroni
>
> make sure that you have run "CATPROC.SQL" in ORACLE_HOME/rdbms/admin
> --
> ==============================================
> Connor McDonald
> BHP Information Technology
> Perth, Western Australia
> "The difference between me and a madman is that I am not mad"
> - Salvador Dali
Received on Tue Feb 09 1999 - 11:47:33 CST