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

Grant one of roles to user and restart user connection.

You can revoke unnecessary roles by:

Solution II (Not recommended)

Grant execute on DBMS_AQ package and restart user connection.

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

I hope it was helpful to you. If you have any questions, feel free to ask me in comments below.

Leave a Reply

Feel free to ask me about anything!

avatar
  Subscribe  
Notify of
Close Menu