[SOLVED] PLS-00201: identifier ‘DBMS_AQ’ must be declared

This is a solution for an exception occurred during enqueuing/dequeuing or managing Oracle AQ in PL/SQL.

Unable to execute statement like below.

because of exception:


User has no permission to DBMS_AQ package.


Solution A
Grant one of roles to user and restart user connection.

You can revoke unnecessary roles by:


Solution B (Not recommended)
Grant execute on DBMS_AQ package and restart user connection.

In some cases you have to add sys. prexix to packages

Leave a Reply

Notify of
Close Menu