Visible (OraAQ) Property

Applies To

Description

Specifies the transactional behavior of the enqueue request.

Usage

Q.Visible = transaction_mode

Remarks

This property is applicable only for an Enqueue operation. Possible Values:

· ORAAQ_ENQ_IMMEDIATE (1) - The Enqueue operation constitutes a transaction of its own. Set this property to make the message visible immediately after the Enqueue operation.

· ORAAQ_ENQ_ON_COMMIT (2) (Default) - The Enqueue is part of the current transaction and the message will be visible only after the transaction commits.

Example

Msg.Value = "The visibility option used in the enqueue call is

ORAAQ_ENQ_IMMEDIATE"

Q.Visible = ORAAQ_ENQ_IMMEDIATE

Q.Enqueue()

Data Type

Integer