Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> error:package DBMS_STANDARD must be created before using PL/SQL
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
Received on Fri Nov 16 2001 - 12:38:50 CST
![]() |
![]() |