PLS-00201 DBMS_AQ 看不到問題

建一個存儲過程時報錯,

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>;