|Oracle® Objects for OLE Developer's Guide
11g Release 2 (11.2) for Microsoft Windows
Part Number E12245-01
OraAQ object is instantiated by invoking the
CreateAQ method of the
OraDatabase interface. It represents a queue that is present in the database.
Oracle Objects for OLE provides interfaces for accessing Oracle Database Advanced Queuing (AQ) feature. It makes AQ accessible from popular COM-based development environments such as Visual Basic.
OraAQ Automation interface provides methods for enqueuing and dequeuing messages (encapsulated in the
OraAQMsg object). It also provides a method for monitoring queues for message arrivals.
Client applications provide a
Dispatch interface to the monitor. The monitor checks the queue for messages that meet the application criteria. It then invokes the
NotifyMe method of the
Dispatch interface when these messages are dequeued.
The following diagram illustrates the OO4O AQ Automation objects and their properties.
Example: Enqueuing Messages
Enqueuing messages of type RAW
Enqueuing messages of Oracle object types
Example: Dequeuing messages
NOTE: The following code samples serve as models for dequeuing messages.
A complete AQ sample can be found in
Dequeuing messages of the RAW type
Dequeuing messages of Oracle object types
Example: Monitoring messages
See "Monitoring Messages" for examples illustrating the use of the