All objects invalid in ORACLE
Posted on 2005-05-10
All the stored procedures, functions etc in the Oracle is now invalid. Not sure why...
Whenever I logged on there is this error
ORA-06533: PLS-213: package STANDARD not accessible
Error accessing package DBMS_APPLICATION_INFO
When I do a compile on the object, like alter procedure xxx compile, it gives me the following.
ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
I read about running some scripts in the ADMIN directory. So farm I have tried standard.sql and a few others using the SYS user but its still the same.
Any help is much appreciated. Thanks.