OracleAQDequeueMode Enumeration

Table 12-31 lists all the OracleAQDequeueMode enumeration values with a description of each enumerated value.

Table 31 OracleAQDequeueMode Members

Member Name Description
Browse Reads the message without acquiring any lock on the message. This is equivalent to a SELECT statement.
Locked Reads and obtains a write lock on the message. The lock lasts for the duration of the transaction. This is equivalent to a SELECT FOR UPDATE statement.
Remove

Reads the message and updates or deletes it. This is the default.

The message can be retained in the queue table based on the retention properties

RemoveNoData Confirms receipt of the message but does not deliver the actual message content.

Requirements

Provider ODP.NET, Unmanaged Driver ODP.NET, Managed Driver ODP.NET Core
Assembly Oracle.DataAccess.dll Oracle.ManagedDataAccess.dll Oracle.ManagedDataAccess.dll
Namespace Oracle.DataAccess.Client Oracle.ManagedDataAccess.Client Oracle.ManagedDataAccess.Client
.NET Framework See System Requirements See System Requirements -
.NET (Core) - - See System Requirements

See Also: