Previous Next       Contents Index Glossary
         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)

queuename The 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. Oracle 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