Enqueuing a Message [Specify Options]

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

Text description of the illustration adq11qop13.gif

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.

• If a transformation is specified, it will be applied to the message before enqueuing it to the queue. The transformation must map the message into an object whose type is the ADT type of the queue.

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): 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, 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:

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

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

• Visual Basic (OO4O): Enqueue a message