Using PL/SQL (DBMS_AQADM and DBMS_AQ Packages) to Access AQ

PL/SQL packages, DBMS_AQADM and DBMS_AQ support access to Oracle8i Advanced Queuing administrative and operational functions via the "native" AQ interface.

These functions include the following:

• Create: queue, queue table, non-persistent 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

• Enable, disable, and alter propagation schedule

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

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

• Subscribing for messages in multi-consumer queue

• Browse messages in a queue

• Receive messages from queue/topic

• Register to received messages asynchronously

• Listen for messages on multiple queues/topics

  See Also Oracle8i Supplied PL/SQL Packages 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"