Monday, October 08, 2012

Launching Workflow from PL/SQL Code

The below script will launch  the desired workflow from PL/SQL code:
declare
   v_itemtype   VARCHAR2(50);
   v_itemkey    VARCHAR2(50);
   v_process    VARCHAR2(50);
   v_userkey    VARCHAR2(50);
begin
 
v_itemtype := 'CHANDRATEST'; 
v_itemkey := '1233';
v_userkey := '1233';
v_process := 'CHANDRAPROCESS';
WF_ENGINE.Threshold := -1;
WF_ENGINE.CREATEPROCESS(v_itemtype, v_itemkey, v_process);
wf_engine.setitemuserkey(v_itemtype, v_itemkey, v_userkey );
wf_engine.setitemowner (v_itemtype, v_itemkey,'SYSADMIN');
WF_ENGINE.STARTPROCESS(v_itemtype, v_itemkey);
commit;
exception when others
then
  dbms_output.put_line(SQLERRM);
end;

No comments:

Post a Comment