Home » RDBMS Server » Server Administration » ORA-06553: PLS-213: package STANDARD not accessible
ORA-06553: PLS-213: package STANDARD not accessible [message #53601] Tue, 01 October 2002 05:58 Go to next message
Eddie Chow
Messages: 1
Registered: October 2002
Junior Member
Hi! I use oracle9i for learning purpose. I started a Database and it works for the last several months. But suddently I find the following error when I login by normal user.

***********************************************
ERROR:
ORA-06553: PLS-213: package STANDARD not accessible

Error accessing package DBMS_APPLICATION_INFO
***********************************************
Also when I ,as sysdba, try to drop user, role, etc, I've got PLS-213 Error. And such transactions are rollbacked.

I'd tried to run catproc.sql again and found that the problems are not solved.

Anyone got this problems before?? THANKS!!!!

Report message to a moderator

Re: ORA-06553: PLS-213: package STANDARD not accessible [message #53618 is a reply to message #53601] Tue, 01 October 2002 15:33 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
As the error is stating:

Your SYS.STANDARD package is invalid and cannot be accessed. Check its status by:

select status from dba_objects
where object_name like 'STANDARD' and
object_type in ('PACKAGE','PACKAGE BODY');

Then either recompile the package or re-run catalog.sql and catproc.sql.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: SGA
Next Topic: daily export hanging
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 23:41:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.