4
DBMS_AQ

The DBMS_AQ package provides an interface to Oracle's Advanced Queuing.

See Also: Oracle9i Application Developer's Guide - Advanced Queuing contains information about using DBMS_AQ.

Java Classes

Java interfaces are available for DBMS_AQ and DBMS_AQADM. The Java interfaces are provided in the $ORACLE_HOME/rdbms/jlib/aqapi.jar. Users are required to have EXECUTE privileges on the DBMS_AQIN package to use these interfaces.

Enumerated Constants

When using enumerated constants such as BROWSE, LOCKED, or REMOVE, the PL/SQL constants must be specified with the scope of the packages defining it. All types associated with the operational interfaces have to be prepended with DBMS_AQ. For example: DBMS_AQ.BROWSE.

Table 4-1 Enumerated Constants

Parameter	Options
visibility	IMMEDIATE, ON_COMMIT
dequeue mode	BROWSE, LOCKED, REMOVE, REMOVE_NODATA
navigation	FIRST_MESSAGE, NEXT_MESSAGE, NEXT_TRANSACTION
state	WAITING, READY, PROCESSED, EXPIRED
sequence_deviation	BEFORE, TOP
wait	FOREVER, NO_WAIT
delay	NO_DELAY
expiration	NEVER
namespace	NAMESPACE_AQ, NAMESPACE_ANONYMOUS

Data Structures for DBMS_AQ

Table 4-2 lists the data structures used in both DBMS_AQ and DBMS_AQADM.

Table 4-2 Data structures in DBMS_AQ and DBMS_AQDM  

Data Structures
"Object Name"
"Type Name"
"Agent"
"Enqueue Options Type"
"Dequeue Options Type"
"Message Properties Type"
"AQ Recipient List Type"
"AQ Agent List Type"
"AQ Subscriber List Type"
"AQ Registration Info Type"
"AQ Registration Info List Type"
"AQ Notification Descriptor Type"
"AQ Post Info Type"
"AQ Post Info List Type"
"AQ PL/SQL Callback"