Did you run catalog and catproc.sql as part of the upgrade?
Regards
HJR
--
Resources for Oracle: http://www.hjrdba.com
===============================
"Sunil Pant" <spant_at_eline.com> wrote in message
news:xzUI7.4255$Le.103947_at_sea-read.news.verio.net...
> 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
>
> Please help.
> SP
>
>
>
Received on Thu Nov 15 2001 - 14:44:00 CST
