Operational Interface: Basic Operations, 4 of 16

Enqueue a Message [Specify Options]

Figure 11-3 Use Case Diagram: Enqueue a Message [Specify Options]

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

To specify the options available for the enqueue operation.

Usage Notes

Do not use the immediate option when you want to use LOB locators since LOB locators are valid only for the duration of the transaction. As the immediate option automatically commits the transaction, your locator will not be valid.

The sequence deviation parameter in enqueue options can be used to change the order of processing between two messages. The identity of the other message, if any, is specified by the enqueue options parameter relative msgid. The relationship is identified by the sequence deviation parameter.

Specifying sequence deviation for a message introduces some restrictions for the delay and priority values that can be specified for this message. The delay of this message has to be less than or equal to the delay of the message before which this message is to be enqueued. The priority of this message has to be greater than or equal to the priority of the message before which this message is to be enqueued.
The visibility option must be immediate for non-persistent queues.
Only local recipients are supported are supported for non-persistent queues.

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, AQ Enqueue Option

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: