TOraQueueTable.PurgeQueueTable Method

Purges records from the queue table.

procedure PurgeQueueTable(const PurgeCondition: string; Block: boolean = False; DeliveryMode: TQueueDeliveryMode = qdmPersistent);

Parameters

PurgeCondition

Specifies the purge condition, which must be in the format of a SQL WHERE clause and is based on the columns of aq$queue_table_name view.

Block

Specifies whether to hold an exclusive lock on all the queues in the queue table while purging the queue table.

DeliveryMode

Specifies which type of messages should be purged. Possible values are described in TDequeueOptions.DeliveryMode topic

Call the PurgeQueueTable method to purge records from the queue table.