The body of the rule will be
DECLARE v_col_Id integer; v_col_WF varchar2(255); v_col_activity varchar2(255); begin select col_id, col_workflow, col_activity into v_col_Id, v_col_WF, v_col_activity from tbl_WI where col_instanceId = :instance_id; :id := v_col_id; :wf := v_col_WF; :activity := v_col_activity; end; |