Re: error:package DBMS_STANDARD must be created before using PL/SQL

Sunil Pant wrote:
>
> I recently upgraded to Oracle 8.1.7 Enterprise from 8.15 in solaris 8. I
> also did run catalog.sql and catproc.sql.
> Now when I open SQLPLUS it gives the follwoing error:
>
> ERROR:
> ORA-06553: PLS-707: unsupported construct or
> internal error [2603]
> Error accessing package
> DBMS_APPLICATION_INFO
> ERROR:
> ORA-06553: PLS-707: unsupported construct or
> internal error [2603]
>
> When I try to create a stored procedure it gives the follwoing error:
>
> CREATE OR REPLACE PROCEDURE
> dms_topic_flag (Pbatch_size IN NUMBER,
> *
> ERROR at line 1:
> ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
>
> So is there a work around to this or do I've to recreate the database and
> re-import the objects?
> Please help.
> SP

Did you check to see if DBMS_STANDARD exists (hint - look at ALL_OBJECTS) and if the package is valid?

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.