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.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google