PLS-00201错怎么解决

来源:互联网 发布:手机看美剧用什么软件 编辑:程序博客网 时间:2024/05/16 11:13
SQL> set serveroutput on
ERROR:
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


SQL> exec dbms_output.enable(10000);
BEGIN dbms_output.enable(10000); END;

      *
ERROR at line 1:
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




执行几个sql scriptj即可:
as SYS 
Oracle_home/rdbms/admin/catalog.sql
Oracle_home/rdbms/admin/catsnmp.sql
Oracle_home/rdbms/admin/catexp7.sql
Oracle_home/rdbms/admin/catproc.sql
Oracle_home/rdbms/admin/caths.sql
as SYSTEM 
Oracle_home/rdbms/admin/catdbsyn.sql