davidnlt
asked on
All objects invalid in ORACLE
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.
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.
Was the DB working before? What version are you on?
ASKER
It was working before this. I have loaded 4 schemas insides. Not sure why its invalid now.
Version : 7.3.3.0.0
Version : 7.3.3.0.0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Its okay now after I run standard.sql and dbmsstd.sql (as recommended from Oracle). It did not work previously because there was 2 version of Oracle on the server and I ran the wrong scripts.
Anyway, thanks for the reply.
Anyway, thanks for the reply.