WF_ENGINE_BULK.StartProcess

PL/SQL Syntax

procedure StartProcess
  (itemtype in varchar2,
   itemkeys in wf_engine_bulk.itemkeytabtype);

Description

Begins execution of multiple new runtime process instances at once, identified by the specified item type and array of workflow item keys. The Workflow Engine locates the activity marked as a Start activity in the process definition and then defers that activity for each of the new work items. Ensure that you run a background engine to process the deferred activities and continue executing the work items.

You must call either WF_ENGINE.CreateProcess() or WF_ENGINE_BULK.CreateProcess() to define the item type and item keys before calling WF_ENGINE_BULK.StartProcess().

Note: You cannot use WF_ENGINE_BULK.StartProcess() to start forced synchronous processes.

If processing fails for any work items, then WF_ENGINE_BULK.StartProcess() adds those item keys to a global PL/SQL table called g_FailedItems within the WF_ENGINE_BULK package. The procedure then continues processing the remaining items. When processing is complete, the procedure raises an exception for any failed items.

Arguments (input)

itemtype A valid item type.
itemkeys An array of item keys that identify the work items to be started. An item key is a string derived from the application object's primary key that uniquely identifies a work item within an item type.

Note: The item key for a work item can only contain single-byte characters. It cannot contain a multibyte value.

You must provide a unique item key for each work item to be started. You cannot use WF_ENGINE_BULK.StartProcess() to start forced synchronous processes with the generic #SYNCH item key.

Related Topics