A
Oracle Advanced Queuing by Example

In this appendix we provide examples of operations using different programatic environments:

• Create Queue Tables and Queues
  • Create a Queue Table and Queue of Object Type

  • Create a Queue Table and Queue of Raw Type

  • Create a Prioritized Message Queue Table and Queue

  • Create a Multiple-Consumer Queue Table and Queue

  • Create a Queue to Demonstrate Propagation

  • Setup for Java AQ Examples

  • Create an Java AQ Session

  • Create a Queue Table and Queue Using Java

  • Create a Queue and Start Enqueue/Dequeue Using Java

  • Create a Multi-Consumer Queue and Add Subscribers Using Java

• Enqueue and Dequeue Of Messages
  • Enqueue and Dequeue of Object Type Messages Using PL/SQL

  • Enqueue and Dequeue of Object Type Messages Using Pro*C/C++

  • Enqueue and Dequeue of Object Type Messages Using OCI

  • Enqueue and Dequeue of Object Type Messages (CustomDatum interface) Using Java

  • Enqueue and Dequeue of Object Type Messages (using SQLData interface) Using Java

  • Enqueue and Dequeue of RAW Type Messages Using PL/SQL

  • Enqueue and Dequeue of RAW Type Messages Using Pro*C/C++

  • Enqueue and Dequeue of RAW Type Messages Using OCI

  • Dequeue of Messages Using Java

  • Dequeue of Messages in Browse Mode Using Java

  • Enqueue and Dequeue of Messages by Priority Using PL/SQL

  • Enqueue of Messages with Priority Using Java

  • Dequeue of Messages after Preview by Criterion Using PL/SQL

  • Enqueue and Dequeue of Messages with Time Delay and Expiration Using PL/SQL

  • Enqueue and Dequeue of Messages by Correlation and Message ID Using Pro*C/C++

  • Enqueue and Dequeue of Messages by Correlation and Message ID Using OCI

  • Enqueue and Dequeue of Messages to/from a Multiconsumer Queue Using PL/SQL

  • Enqueue and Dequeue of Messages to/from a Multiconsumer Queue using OCI

  • Enqueue and Dequeue of Messages Using Message Grouping Using PL/SQL

  • Enqueuing and Dequeuing Object Type Messages That Contain LOB Attributes Using PL/SQL

  • Enqueuing and Dequeuing Object Type Messages That Contain LOB Attributes Using Java

• Propagation
  • Enqueue of Messages for remote subscribers/recipients to a Multiconsumer Queue and Propagation Scheduling Using PL/SQL

  • Manage Propagation From One Queue To Other Queues In The Same Database Using PL/SQL

  • Manage Propagation From One Queue To Other Queues In Another Database Using PL/SQL

  • Unscheduling Propagation Using PL/SQL

• Drop AQ Objects

• Revoke Roles and Privileges

• Deploy AQ with XA

• AQ and Memory Usage
  • Enqueue Messages (Free Memory After Every Call) Using OCI

  • Enqueue Messages (Reuse Memory) Using OCI

  • Dequeue Messages (Free Memory After Every Call) Using OCI

  • Dequeue Messages (Reuse Memory) Using OCI