Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to fix the error message: pls-213 package standard not accessible
- Thread starter franco44
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
Just run $ORACLE_HOME/rdbms/admin/catproc.sql as SYSDBA.
-Bhavesh
-Bhavesh
tigreeuropeo
IS-IT--Management
The package STANDARD (that belongs to the user SYS) is INVALID, there are a lot of reasons why this package turned to this state.
Use this to check the INVALID packages:
connect sys/passwd@yourdb
select object_name from obj where status = 'INVALID' and object_type = 'PACKAGE';
There, you have the packages that are invalid, then you have to recompile the invalid packages, until every of them are VALID.
Use this:
select 'ALTER PACKAGE ',object_name,' compile;' where status = 'INVALID' and object_type = 'PACKAGE';
Then execute the resulting rows from the query above.
Good luck.
Use this to check the INVALID packages:
connect sys/passwd@yourdb
select object_name from obj where status = 'INVALID' and object_type = 'PACKAGE';
There, you have the packages that are invalid, then you have to recompile the invalid packages, until every of them are VALID.
Use this:
select 'ALTER PACKAGE ',object_name,' compile;' where status = 'INVALID' and object_type = 'PACKAGE';
Then execute the resulting rows from the query above.
Good luck.
- Status
Similar threads
