PLS-00201 DBMS_AQ 看不到问题
来源:互联网 发布:金十数据那个版本好用 编辑:程序博客网 时间:2024/04/29 20:30
建一个存储过程时报错,
4/19 PLS-00201: identifier 'DBMS_AQ' must be declared
4/19 PL/SQL: Item ignored
5/22 PLS-00201: identifier 'DBMS_AQ' must be declared
5/22 PL/SQL: Item ignored
7/11 PLS-00201: identifier 'PABSE_AQADMIN.MESSAGE_TYP' must be
declared
用到了dbms_aq包,需要对AQ USER,AQ ADMIN用户进行授权, 格式如下
SYS>grant execute on DBMS_AQ to my_username;
GRANT RESOURCE TO <UserName>;
GRANT CONNECT TO <UserName>;
GRANT EXECUTE ANY PROCEDURE TO <UserName>;
GRANT aq_administrator_role TO <UserName>;
GRANT aq_user_role TO <UserName>;
GRANT EXECUTE ON dbms_aqadm TO <UserName>;
GRANT EXECUTE ON dbms_aq TO <UserName>;
GRANT EXECUTE ON dbms_aqin TO <UserName>;
4/19 PLS-00201: identifier 'DBMS_AQ' must be declared
4/19 PL/SQL: Item ignored
5/22 PLS-00201: identifier 'DBMS_AQ' must be declared
5/22 PL/SQL: Item ignored
7/11 PLS-00201: identifier 'PABSE_AQADMIN.MESSAGE_TYP' must be
declared
用到了dbms_aq包,需要对AQ USER,AQ ADMIN用户进行授权, 格式如下
SYS>grant execute on DBMS_AQ to my_username;
GRANT RESOURCE TO <UserName>;
GRANT CONNECT TO <UserName>;
GRANT EXECUTE ANY PROCEDURE TO <UserName>;
GRANT aq_administrator_role TO <UserName>;
GRANT aq_user_role TO <UserName>;
GRANT EXECUTE ON dbms_aqadm TO <UserName>;
GRANT EXECUTE ON dbms_aq TO <UserName>;
GRANT EXECUTE ON dbms_aqin TO <UserName>;
0 0
- PLS-00201 DBMS_AQ 看不到问题
- oracle pls-00201 问题
- pls:00201 00304
- set_sql_trace_in_session PLS-00201
- Error: PLS-00201
- Error: PLS-00201
- Error: PLS-00201
- PLS-00201错怎么解决
- PLS-00201和IMP-00013
- 嵌套表事例和PLS-00642问题
- apache看不到服务等问题
- Oracle Advanced Queue (DBMS_AQ/DMBS_AQADM)
- PLS-00201:必须说明标识符‘SHOW_SPACE'
- 创建oracle快照时报PLS-00201:
- Error: PLS-00201: 必须声明标识符 'EVEN'
- oracle运行存储过程报PLS-00201
- PLS-00201: 必须声明标识符 'PKG_CONST.R_CURSOR'
- 小知识--网上邻居看不到其他计算机的问题
- 安装 oracle soa suite x86 101310 的一点经验
- ios8中使用地图已经改变了
- ORACLE SOA SUITE ORABPEL-12133 错误解决
- 安装SOA SUITE并使用ORACLE XE数据库作为组件要点.
- 猜叔叔的出生年月日 今年的植树节(2012年3月12日),小明和他的叔叔还有小伙伴们一起去植树。
- PLS-00201 DBMS_AQ 看不到问题
- PL/SQL 对AQ 进行enqueue操作样例
- InfoQ Editors' Recommended Reading List
- org.hibernate.HibernateException: No CurrentSessio
- 如何成为一个杰出的程序员?
- 过程式语言与面向对象语言的区别
- Linux操作命令(十)
- GlassFish 2.1 配置mysql连接池
- 开源日志系统log4cplus(五)