The below script will lanch or kickoff the desired workflow from PL/SQL code:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
declare v_itemtype VARCHAR2(50); v_itemkey VARCHAR2(50); v_process VARCHAR2(50); v_userkey VARCHAR2(50); begin v_itemtype := ‘DEMOIT’; v_itemkey := ‘1233’; v_userkey := ‘1233’; v_process := ‘DEMOPROCESS’; 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; |