Even after connecting as SYS and running all the following files:
I am getting the following error:
CREATE OR REPLACE PROCEDURE PRO_CP_KYUUHU(
ERROR at line 1:
ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
Sign on to the database as SYS and run CATALOG.SQL. You didn't list that in your list of scripts that are run. I've had the same problem with DBMS_STANDARD and running CATALOG.SQL has fixed my problem every time.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.