dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleQueueTable Class / PurgeQueueTable Method / PurgeQueueTable(String,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.
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,OracleQueueDeliveryMode) Method
    In This Topic
    Purges messages from queue tables.
    Syntax
    'Declaration
     
    Public Overloads Sub PurgeQueueTable( _
       ByVal condition As String, _
       ByVal deliveryMode As OracleQueueDeliveryMode _
    ) 
    public void PurgeQueueTable( 
       string condition,
       OracleQueueDeliveryMode deliveryMode
    )

    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.
    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.)
    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also