Home » RDBMS Server » Server Administration » Urgent ."Error accessing package DBMS_APPLICATION_INFO "
Urgent ."Error accessing package DBMS_APPLICATION_INFO " [message #54932] Tue, 17 December 2002 02:04 Go to next message
Aparna Venkatraman
Messages: 14
Registered: October 2002
Junior Member
Hello!

Im getting the following error when i try to open a sql session or compile a form using Oracle 8i.

" Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06553: PLS-213: package STANDARD not accessible "

Kindly help me out ASAP

Thanks in Advance
Aparna Venkatraman
Re: Urgent ."Error accessing package DBMS_APPLICATION_INFO " [message #54936 is a reply to message #54932] Tue, 17 December 2002 06:44 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
--	connect as sys
SQL> connect sys/sys
Connected.
-- 	check the status of package standard
SQL> select object_name,status from dba_objects where OBJECT_NAME='STANDARD';

OBJECT_NAM STATUS
---------- -------
STANDARD   VALID
STANDARD   VALID

-- if invalid status then , recompile it

SQL> alter package standard compile;

Package altered.

-- 	try to business again.
-- 	still error? then recrecreate the object logged in as sys.
-- 	run the following script as sys

SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql

Previous Topic: Re: enabling Object features in Oracle 8
Next Topic: connecting problem
Goto Forum:
  


Current Time: Sat Dec 28 04:34:32 CST 2024