|Oracle9i Application Developer's Guide - Advanced Queuing
Release 1 (9.0.1)
Part Number A88890-02
Operational Interface: Basic Operations, 4 of 19
To refer to the table of all basic operations having to do with the Operational Interface see:
To specify the options available for the enqueue operation.
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.
sequence deviationparameter 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 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.
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:
See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Examples in the following programmatic environments are provided: