Enqueue a Message

Figure 11-2 Use Case Diagram: Enqueue a Message

To refer to the table of all basic operations having to do with the Operational Interface see: "Use Case Model: Operational Interface -- Basic Operations"

Purpose:

Adds a message to the specified queue.

Usage Notes

• 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.

Syntax

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): Oracle8i Supplied PL/SQL Packages 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): Oracle8i Supplied Java Packages Reference,oracle.jms, AQOracleQueue.enque

Examples

See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Examples in the following programmatic environments are provided:

• PL/SQL (DBMS_AQ Package): Enqueue of Object Type Messages

• Java (JDBC): Enqueue a message (add payload)

• Visual Basic (OO4O): Enqueue a message