Thursday, December 10, 2009

Handy Script to CleanUp WFERROR Workflow Item Type

There was a request to cleanup 100's of WFERROR in Workflow. This simple script can help to do it at the backend;

DECLARE 
     CURSOR wf_error IS 
     SELECT item_key 
     FROM wf_items 
     WHERE item_type = 'WFERROR' 
          AND end_date is null; 
BEGIN 
         FOR i IN wf_error LOOP 
               WF_ENGINE.abortProcess('WFERROR', i.item_key); 
         END LOOP; 

COMMIT; 
END; 

Popular Posts