.. _dpiDeqOptionsFunctions:
ODPI-C Dequeue Options Functions
--------------------------------
Dequeue option handles are used to represent the options specified when
dequeuing messages using advanced queueing. They are created by calling the
function :func:`dpiConn_newDeqOptions()` and are destroyed by releasing the
last reference by calling the function :func:`dpiDeqOptions_release()`.
.. function:: int dpiDeqOptions_addRef(dpiDeqOptions \*options)
Adds a reference to the dequeue options. This is intended for situations
where a reference to the dequeue options needs to be maintained
independently of the reference returned when the handle was created.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- the dequeue options to which a reference is to be
added. If the reference is NULL or invalid an error is returned.
.. function:: int dpiDeqOptions_getCondition(dpiDeqOptions \*options, \
const char \** value, uint32_t \*valueLength)
Returns the condition that must be satisfied in order for a message to be
dequeued. See function :func:`dpiDeqOptions_setCondition()` for more
information.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options from which the
condition is to be retrieved. If the reference is NULL or invalid an error
is returned.
**value** [OUT] -- a pointer to the value, as a byte string in the encoding
used for CHAR data, which will be populated upon successful completion of
this function. If there is no condition, the pointer will be populated with
the value NULL.
**valueLength** [OUT] -- a pointer to the length of the value, in bytes,
which will be populated upon successful completion of this function. If
there is no condition, the pointer will be populated with the value 0.
.. function:: int dpiDeqOptions_getConsumerName(dpiDeqOptions \*options, \
const char \** value, uint32_t \*valueLength)
Returns the name of the consumer that is dequeuing messages. See function
:func:`dpiDeqOptions_setConsumerName()` for more information.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options from which the
consumer name is to be retrieved. If the reference is NULL or invalid an
error is returned.
**value** [OUT] -- a pointer to the value, as a byte string in the encoding
used for CHAR data, which will be populated upon successful completion of
this function. If there is no consumer name, the pointer will be populated
with the value NULL.
**valueLength** [OUT] -- a pointer to the length of the value, in bytes,
which will be populated upon successful completion of this function. If
there is no consumer name, the pointer will be populated with the value 0.
.. function:: int dpiDeqOptions_getCorrelation(dpiDeqOptions \*options, \
const char \** value, uint32_t \*valueLength)
Returns the correlation of the message to be dequeued. See function
:func:`dpiDeqOptions_setCorrelation()` for more information.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options from which the
correlation is to be retrieved. If the reference is NULL or invalid an
error is returned.
**value** [OUT] -- a pointer to the value, as a byte string in the encoding
used for CHAR data, which will be populated upon successful completion of
this function. If there is no correlation, the pointer will be populated
with the value NULL.
**valueLength** [OUT] -- a pointer to the length of the value, in bytes,
which will be populated upon successful completion of this function. If
there is no correlation, the pointer will be populated with the value 0.
.. function:: int dpiDeqOptions_getMode(dpiDeqOptions \*options, \
dpiDeqMode \*value)
Returns the mode that is to be used when dequeuing messages.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options from which the mode
is to be retrieved. If the reference is NULL or invalid an error is
returned.
**value** [OUT] -- a pointer to the value, which will be populated upon
successful completion of this function. It will be one of the values from
the enumeration :ref:`dpiDeqMode<dpiDeqMode>`.
.. function:: int dpiDeqOptions_getMsgId(dpiDeqOptions \*options, \
const char \** value, uint32_t \*valueLength)
Returns the identifier of the specific message that is to be dequeued.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options from which the
message identifier is to be retrieved. If the reference is NULL or invalid
an error is returned.
**value** [OUT] -- a pointer to the value, which will be populated upon
successful completion of this function. If there is no message identifier,
the pointer will be populated with the value NULL.
**valueLength** [OUT] -- a pointer to the length of the value, in bytes,
which will be populated upon successful completion of this function. If
there is no message identifier, the pointer will be populated with the
value 0.
.. function:: int dpiDeqOptions_getNavigation(dpiDeqOptions \*options, \
dpiDeqNavigation \*value)
Returns the position of the message that is to be dequeued.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options from which the
navigation option is to be retrieved. If the reference is NULL or invalid
an error is returned.
**value** [OUT] -- a pointer to the value, which will be populated upon
successful completion of this function. It will be one of the values from
the enumeration :ref:`dpiDeqNavigation<dpiDeqNavigation>`.
.. function:: int dpiDeqOptions_getTransformation(dpiDeqOptions \*options, \
const char \** value, uint32_t \*valueLength)
Returns the transformation of the message to be dequeued. See function
:func:`dpiDeqOptions_setTransformation()` for more information.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options from which the
transformation is to be retrieved. If the reference is NULL or invalid an
error is returned.
**value** [OUT] -- a pointer to the value, as a byte string in the encoding
used for CHAR data, which will be populated upon successful completion of
this function. If there is no transformation, the pointer will be populated
with the value NULL.
**valueLength** [OUT] -- a pointer to the length of the value, in bytes,
which will be populated upon successful completion of this function. If
there is no transformation, the pointer will be populated with the value 0.
.. function:: int dpiDeqOptions_getVisibility(dpiDeqOptions \*options, \
dpiVisibility \*value)
Returns whether the message being dequeued is part of the current
transaction or constitutes a transaction on its own.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options from which the
visibility is to be retrieved. If the reference is NULL or invalid an error
is returned.
**value** [OUT] -- a pointer to the value, which will be populated upon
successful completion of this function. It will be one of the values from
the enumeration :ref:`dpiVisibility<dpiVisibility>`.
.. function:: int dpiDeqOptions_getWait(dpiDeqOptions \*options, \
uint32_t \*value)
Returns the time to wait, in seconds, for a message matching the search
criteria. See function :func:`dpiDeqOptions_setWait()` for more
information.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options from which the wait
time is to be retrieved. If the reference is NULL or invalid an error is
returned.
**value** [OUT] -- a pointer to the value, which will be populated upon
successful completion of this function.
.. function:: int dpiDeqOptions_release(dpiDeqOptions \*options)
Releases a reference to the dequeue options. A count of the references to
the dequeue options is maintained and when this count reaches zero, the
memory associated with the options is freed.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- the dequeue options from which a reference is to be
released. If the reference is NULL or invalid an error is returned.
.. function:: int dpiDeqOptions_setCondition(dpiDeqOptions \*options, \
const char \* value, uint32_t valueLength)
Sets the condition which must be true for messages to be dequeued. The
condition must be a valid boolean expression similar to the where clause
of a SQL query. The expression can include conditions on message
properties, user data properties and PL/SQL or SQL functions. User data
properties must be prefixed with tab.user_data as a qualifier to indicate
the specific column of the queue table that stores the message payload.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options on which the
condition is to be set. If the reference is NULL or invalid an error is
returned.
**value** [IN] -- a byte string in the encoding used for CHAR data, or NULL
if the condition is to be cleared.
**valueLength** [IN] -- the length of the value parameter in bytes, or 0 if
the value parameter is NULL.
.. function:: int dpiDeqOptions_setConsumerName(dpiDeqOptions \*options, \
const char \* value, uint32_t valueLength)
Sets the name of the consumer which will be dequeuing messages. This value
should only be set if the queue is set up for multiple consumers.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options on which the
consumer name is to be set. If the reference is NULL or invalid an error is
returned.
**value** [IN] -- a byte string in the encoding used for CHAR data, or NULL
if the consumer name is to be cleared.
**valueLength** [IN] -- the length of the value parameter in bytes, or 0 if
the value parameter is NULL.
.. function:: int dpiDeqOptions_setCorrelation(dpiDeqOptions \*options, \
const char \* value, uint32_t valueLength)
Sets the correlation of the message to be dequeued. Special pattern
matching characters such as the percent sign (%) and the underscore (_)
can be used. If multiple messages satisfy the pattern, the order of
dequeuing is undetermined.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options on which the
correlation is to be set. If the reference is NULL or invalid an error is
returned.
**value** [IN] -- a byte string in the encoding used for CHAR data, or NULL
if the correlation is to be cleared.
**valueLength** [IN] -- the length of the value parameter in bytes, or 0 if
the value parameter is NULL.
.. function:: int dpiDeqOptions_setDeliveryMode(dpiDeqOptions \*options, \
dpiMessageDeliveryMode value)
Sets the message delivery mode that is to be used when dequeuing messages.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options on which the message
delivery mode is to be set. If the reference is NULL or invalid an error is
returned.
**value** [IN] -- the mode that should be used. It should be one of the
values from the enumeration
:ref:`dpiMessageDeliveryMode<dpiMessageDeliveryMode>`.
.. function:: int dpiDeqOptions_setMode(dpiDeqOptions \*options, \
dpiDeqMode value)
Sets the mode that is to be used when dequeuing messages.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options on which the mode is
to be set. If the reference is NULL or invalid an error is returned.
**value** [IN] -- the mode that should be used. It should be one of the
values from the enumeration :ref:`dpiDeqMode<dpiDeqMode>`.
.. function:: int dpiDeqOptions_setMsgId(dpiDeqOptions \*options, \
const char \* value, uint32_t valueLength)
Sets the identifier of the specific message to be dequeued.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options on which the message
identifier to dequeue is to be set. If the reference is NULL or invalid an
error is returned.
**value** [IN] -- a pointer to the bytes making up the message identifier,
or NULL if no specific message is to be dequeued.
**valueLength** [IN] -- the length of the value parameter in bytes, or 0 if
the value parameter is NULL.
.. function:: int dpiDeqOptions_setNavigation(dpiDeqOptions \*options, \
dpiDeqNavigation value)
Sets the position in the queue of the message that is to be dequeued.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options on which the
navigation option is to be set. If the reference is NULL or invalid an
error is returned.
**value** [IN] -- the value that should be used. It should be one of the
values from the enumeration :ref:`dpiDeqNavigation<dpiDeqNavigation>`.
.. function:: int dpiDeqOptions_setTransformation(dpiDeqOptions \*options, \
const char \* value, uint32_t valueLength)
Sets the transformation of the message to be dequeued. The transformation
is applied after the message is dequeued but before it is returned to the
application. It must be created using DBMS_TRANSFORM.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options on which the
transformation is to be set. If the reference is NULL or invalid an error
is returned.
**value** [IN] -- a byte string in the encoding used for CHAR data, or NULL
if the transformation is to be cleared.
**valueLength** [IN] -- the length of the value parameter in bytes, or 0 if
the value parameter is NULL.
.. function:: int dpiDeqOptions_setVisibility(dpiDeqOptions \*options, \
dpiVisibility value)
Sets whether the message being dequeued is part of the current transaction
or constitutes a transaction on its own.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options on which the
visibility is to be set. If the reference is NULL or invalid an error is
returned.
**value** [IN] -- the value that should be used. It should be one of the
values from the enumeration :ref:`dpiVisibility<dpiVisibility>`.
.. function:: int dpiDeqOptions_setWait(dpiDeqOptions \*options, \
uint32_t value)
Set the time to wait, in seconds, for a message matching the search
criteria.
The function returns DPI_SUCCESS for success and DPI_FAILURE for failure.
**options** [IN] -- a reference to the dequeue options from which the wait
time is to be retrieved. If the reference is NULL or invalid an error is
returned.
**value** [IN] -- the number of seconds to wait for a message matching the
search criteria. Any integer is valid but the predefined constants
DPI_DEQ_WAIT_NO_WAIT and DPI_DEQ_WAIT_FOREVER are provided as a
convenience.