Using OCI to Access AQ

Oracle Call Interface (OCI) provides an interface to Oracle Advanced Queuing functions using the native AQ interface.

An OCI client can perform the following actions:

• Enqueue messages

• Dequeue messages

• Listen for messages on sets of queues

• Register to receive message notifications

In addition, OCI clients can receive asynchronous notifications for new messages in a queue using OCISubscriptionRegister.

See: Oracle Call Interface Programmer's Guide: "OCI and Advanced Queuing" and "Publish-Subscribe Notification" sections, for syntax details.

For queues with user-defined payload type, OTT must be used to generate the OCI mapping for the Oracle type. The OCI client is responsible for freeing the memory of the AQ descriptors and the message payload.

Examples

OCI Interface

See Appendix A, "Oracle Advanced Queuing by Example", under "Enqueuing and Dequeuing Of Messages" , for OCI Advanced Queuing interface examples.

Managing OCI Descriptor Memory

See Appendix A, "Oracle Advanced Queuing by Example", "AQ and Memory Usage" , for examples illustrating memory management of OCI descriptors.