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
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
- PLS-00201错怎么解决
- PLS-00565的错误解决
- pls:00201 00304
- set_sql_trace_in_session PLS-00201
- oracle pls-00201 问题
- Error: PLS-00201
- Error: PLS-00201
- Error: PLS-00201
- PLS-00201和IMP-00013
- PLS-00201 DBMS_AQ 看不到问题
- oracle 11.2.0.3 expdp 时报错,PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
- 【解决】EXP-00056 ORA-06550 PLS-00302 ORA-06550错误
- PLS-00201:必须说明标识符‘SHOW_SPACE'
- 创建oracle快照时报PLS-00201:
- Error: PLS-00201: 必须声明标识符 'EVEN'
- oracle运行存储过程报PLS-00201
- PLS-00201: 必须声明标识符 'PKG_CONST.R_CURSOR'
- 创建存储过程报错PLS-00410
- 架构语言ArchiMate -业务层(Business Layer)
- iOS-UIImageView添加事件
- android中ListView 设定背景图后拖动时整体背景变黑的解决
- 黑马程序员——Java 多线程
- iOS-UINavigationController导航 页面切换效果
- PLS-00201错怎么解决
- python 的列表遍历删除
- iOS-UITextField和UITextView隐藏键盘
- RMAN备份时遇到要求重建standard包的错误 ORA-06554 RMAN-04015
- java实现SSL双向认证
- Hibernate 一对多映射
- iOS-UITableView 实现分页显示的代码
- android FAILED Binder Transaction 问题的原因
- U-boot给kernel传参数和kernel读取参数—struct tag