[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.

Problem
Unable to execute statement like below.

because of exception:

 

Cause
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

avatar
  Subscribe  
Notify of
Close Menu