declare v_itemtype VARCHAR2(50); v_itemkey VARCHAR2(50); v_process VARCHAR2(50); v_userkey VARCHAR2(50); begin v_itemtype := 'DEMOWF'; 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;
Thursday, October 4, 2012
How to Launch Workflow from PL/SQL
Labels:
backend,
pl/sql,
workflow tools,
Workflows