Using PL/SQL to Access AQ

PL/SQL packages, DBMS_AQADM and DBMS_AQ support access to Oracle Advanced Queuing administrative and operational functions using the native AQ interface. These functions include the following:

• Create: queue, queue table, nonpersistent queue, multi-consumer queue/topic, RAW message, message with structured data

• Get: queue table, queue, multi-consumer queue/topic

• Alter: queue table, queue/topic

• Drop: queue/topic

• Start or stop: queue/topic

• Grant and revoke privileges

• Add, remove, alter subscriber

• Add, remove, alter AQ internet agents

• Grant or revoke privileges of database users to AQ internet agents

• Enable, disable, and alter propagation schedule

• Enqueue messages to single consumer queue (point-to-point model)

• Publish messages to multi-consumer queue/topic (publish-subscribe model)

• Subscribing for messages in multi-consumer queue

• Browse messages in a queue

• Receive messages from queue/topic

• Register to receive messages asynchronously

• Listen for messages on multiple queues/topics

• Post messages to anonymous subscriptions

• Bind or unbind agents in a LDAP server

• Add or remove aliases to AQ objects in a LDAP server

  See Also: Oracle9i Supplied PL/SQL Packages and Types Reference for detailed documentation, including parameters, parameter types, return values, examples, DBMS_AQADM and DBMS_AQ syntax.

Available PL/SQL DBMS_AQADM and DBMS_AQ functions are listed in detail in the following tables:

• Table 3-2, "Comparing AQ Programmatic Environments: Administrative Interfaces"

• Table 3-3, "Comparing AQ Programmatic Environments: Operational Interfaces"