How to Fix PLS-00201: identifier 'DBMS_AQ' must be declared

_____________________________________________________________________________________________________________________

Error Description:

Procedure compilation failed with following error.

PLS-00201: identifier 'DBMS_AQ' must be declared

Solution Description

You have to grant the execute privilege on package DBMS_AQ to the particular user who owns the procedure.

SQL> alter procedure usr.MSG_RESUBMIT compile;

Warning: Procedure altered with compilation errors.

SQL> show error

Errors for PROCEDURE USR.MSG_RESUBMIT:

LINE/COL ERROR

-------- -----------------------------------------------------------------

8/21     PL/SQL: Item ignored

8/21     PLS-00201: identifier 'DBMS_AQ' must be declared

SQL> grant execute on DBMS_AQ to usr;

Grant succeeded.

SQL> grant execute on DBMS_AQ to usr;

Grant succeeded.

SQL> alter procedure usr.MSG_RESUBMIT compile;

Procedure altered.

_____________________________________________________________________________________________________________________

Website Stats