I don't remember whether I ran that as part of the upgrade. But I did
surely run it after that.
SP
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:3bf42932$0$384$afc38c87_at_news.optusnet.com.au...
> 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 - 15:59:23 CST
