dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleQueueTable Class / PurgeQueueTable Method / PurgeQueueTable(String,Boolean,OracleQueueDeliveryMode) Method
Specifies the purge condition to use when purging the queue table. The purge condition must be in the format of a SQL WHERE clause, and it is case-sensitive. The condition is based on the columns of aq$queue_table view.
If block is true, then an exclusive lock on all the queues in the queue table is held while purging the queue table. This will cause concurrent enqueuers and dequeuers to block while the queue table is purged. The purge call always succeeds if block is true. This will not block enqueuers and dequeuers, but it can cause the purge to fail with an error during high concurrency times.
This parameter is used to specify delivery mode of messages are to be purged. You cannot implement arbitrary purge conditions if buffered messages have to be purged. (Used in Oracle Server 10.2 only.)

In This Topic
PurgeQueueTable(String,Boolean,OracleQueueDeliveryMode) Method
In This Topic
Purges messages from queue tables.
Syntax
'Declaration
 
Public Overloads Sub PurgeQueueTable( _
   ByVal condition As String, _
   ByVal block As Boolean, _
   ByVal deliveryMode As OracleQueueDeliveryMode _
) 
 

Parameters

condition
Specifies the purge condition to use when purging the queue table. The purge condition must be in the format of a SQL WHERE clause, and it is case-sensitive. The condition is based on the columns of aq$queue_table view.
block
If block is true, then an exclusive lock on all the queues in the queue table is held while purging the queue table. This will cause concurrent enqueuers and dequeuers to block while the queue table is purged. The purge call always succeeds if block is true. This will not block enqueuers and dequeuers, but it can cause the purge to fail with an error during high concurrency times.
deliveryMode
This parameter is used to specify delivery mode of messages are to be purged. You cannot implement arbitrary purge conditions if buffered messages have to be purged. (Used in Oracle Server 10.2 only.)
See Also