|Oracle9i Application Developer's Guide - Advanced Queuing
Release 1 (9.0.1)
Part Number A88890-02
Operational Interface: Basic Operations, 3 of 19
Enqueuing a Message
Figure 11-2 Use Case Diagram: Enqueuing a Message
Text description of the illustration adq11qop12.gif
Adds a message to the specified queue.
- If a message is enqueued to a multi-consumer queue with no recipient and the queue has no subscribers (or rule-based subscribers that match this message), then the Oracle error ORA 24033 is raised. This is a warning that the message will be discarded since there are no recipients or subscribers to whom it can be delivered.
See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Use the following syntax references for each programmatic environment:
- PL/SQL (DBMS_AQ Package): Oracle9i Supplied PL/SQL Packages and Types Reference DBMS_AQ, ENQUEUE procedure
- Visual Basic (OO4O) (Oracle Objects for OLE (OO4O) Online Help): From Help Topics, Contents tab, select OO4O Automation Server > OBJECTS > OraAQ
- Java (JDBC): Oracle9i Supplied Java Packages Reference,oracle.jms, AQOracleQueue.enque
See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Examples in the following programmatic environments are provided: