Using OCI to Access AQ

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

An OCI client can perform the following actions:

• Enqueue messages

• Dequeue messages

• Listen for messages on sets of queues.

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 "Enqueue and Dequeue 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.