Jump to Navigation

Create database fails on package STANDARD

While scripting the creation of an Oracle database, I somehow kept getting errors during the CREATE DATABASE:

ORA-06553: PLS-213: package STANDARD not accessible

Very weird. Until I realized I was using a generic scripting function that issued a SET SERVEROUTPUT ON. It turns out that Oracle can not cope with that until you have loaded catalog.sql and catproc.sql.

The actual error after running catalog.sql but before running catproc.sql is:

ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.ENABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Blog_article | by Dr. Radut