Visible (OraAQ) Property

Applies To

OraAQ Object

Description

Specifies the transactional behavior of the enqueue request.

Usage

Q.Visible = transaction_mode

Data Type

Integer

Remarks

This property is applicable only for an enqueue operation.

Possible values are:

• 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 is visible only after the transaction commits.

Examples

Msg.Value = "The visibility option used in the enqueue call is " & _
                    "ORAAQ_ENQ_IMMEDIATE" 
Q.Visible = ORAAQ_ENQ_IMMEDIATE 
Q.Enqueue