| Previous | Next |  | Contents | Index | Glossary

## PurgeItemType

Syntax

`procedure PurgeItemType`

        (queuename in varchar2,

         itemtype in varchar2 default null,

         correlation in varchar2 default null);

Description

Removes all events belonging to a specific item type from a specified queue without further processing.

Arguments (input) | queuenameThe name of the queue from which to purge the events.
itemtype | An optional item type of the events to purge.
correlation | Specify an optional correlation identifier for the message to be purged. Oracle8i Advanced Queues allow you to search a queue for messages based on a specific correlation value. You can use the Like comparison operator, '%', to specify the identifier string. If null, the Workflow Engine creates a correlation identifier based on the item type.

| Previous | Next |  | Contents | Index | Glossary