Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-06554 error while creating a stored procedure
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 - 13:19:57 CST