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