Oracle Built-in Packages

DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)

Before AQ users can enqueue and dequeue, they must have queues with which to work. The AQ administrator must create queue tables and queues within those tables and then start the queues. Additional administrative tasks include stopping queues and removing queue tables, managing lists of subscribers, and starting and stopping the Queue Monitor.

The DBMS_AQADM package provides an interface to the administrative tasks of Oracle AQ. The DBMS_AQADM programs are listed in Table 5.2. In order to use these procedures, a DBMS_AQADM user must have been granted the role AQ_ADMINISTRATOR_ROLE from the SYS account.

Note

None of the DBMS_AQADM programs may be used inside SQL, directly or indirectly. The reason for this restriction is that many of these programs perform a COMMIT (unless you have set the auto_commit parameter to FALSE).

Table 5-2. DBMS_AQADM Programs

Name	Description	Use in SQL?
ADD_SUBSCRIBER	Adds a subscriber to a queue.	No
ALTER_QUEUE	Alters limited set of properties of an existing queue.	No
CREATE_QUEUE	Creates a queue within the specified queue table.	No
CREATE_QUEUE_TABLE	Creates a queue table in which queues can be defined.	No
DROP_QUEUE	Drops an existing queue table.	No
DROP_QUEUE_TABLE	Drops an existing queue from a queue table.	No
GRANT_TYPE_ACCESS	Grants access to multiple consumer tasks.	No
QUEUE_SUBSCRIBERS	Retrieves the list of subscribers associated with a queue.	No