PLS-00201 DBMS_AQ 看不到问题

最新推荐文章于 2023-10-13 17:30:12 发布

最新推荐文章于 2023-10-13 17:30:12 发布 · 242 阅读

文章标签：

#SQL

java 专栏收录该内容

12 篇文章

订阅专栏

本文解决创建存储过程中遇到的PLS-00201错误，具体为标识符未声明的问题，并提供了解决方案，包括对AQUSER和AQADMIN用户的授权步骤。

建一个存储过程时报错,
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>;