The below script will lanch or kickoff the desired workflow from PL\/SQL code:<\/p>\n
v_itemtype := 'DEMOIT'; The below script will lanch or kickoff 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 := ‘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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,499],"tags":[],"class_list":["post-2518","post","type-post","status-publish","format-standard","hentry","category-scripts","category-workflow-scripts"],"yoast_head":"\n
\ndeclare
\n v_itemtype VARCHAR2(50);
\n v_itemkey VARCHAR2(50);
\n v_process VARCHAR2(50);
\n v_userkey VARCHAR2(50);
\nbegin<\/p>\n
\nv_itemkey := '1233';
\nv_userkey := '1233';
\nv_process := 'DEMOPROCESS';
\nWF_ENGINE.Threshold := -1;
\nWF_ENGINE.CREATEPROCESS(v_itemtype, v_itemkey, v_process);
\nwf_engine.setitemuserkey(v_itemtype, v_itemkey, v_userkey );
\nwf_engine.setitemowner (v_itemtype, v_itemkey,'SYSADMIN');
\nWF_ENGINE.STARTPROCESS(v_itemtype, v_itemkey);
\ncommit;
\nexception when others
\nthen
\n dbms_output.put_line(SQLERRM);
\nend; <\/code><\/p>\n","protected":false},"excerpt":{"rendered":"