Trying to start a Workflow from pl/sql code:
I have trippel checked that the application_id, the static_id and the parameter value are all correct.
DECLARE
l_workflow_id NUMBER;
BEGIN
l_workflow_id := apex_workflow.start_workflow(
p_application_id => 401,
p_static_id => 'UPLOAD_DAILY_RATE',
p_parameters => apex_workflow.t_workflow_parameters(1 => apex_workflow.t_workflow_parameter(static_id => 'P_DAILY_RATE_BATCH', string_value => '119829A9D1858543E0634B18000A603F'))
);
END;
ORA-01403: ingen data funnet ORA-06512: ved "APEX_230200.WWV_FLOW_WORKFLOW", line 5786 ORA-06512: ved "APEX_230200.WWV_FLOW_WORKFLOW_API", line 74 ORA-06512: ved line 4 3. BEGIN 4. l_workflow_id := apex_workflow.start_workflow( 5. p_application_id => 401, 6. p_static_id => 'UPLOAD_DAILY_RATE', 7. p_parameters => apex_workflow.t_workflow_parameters(1 => apex_workflow.t_workflow_parameter(static_id => 'P_DAILY_RATE_BATCH', string_value => '119829A9D1858543E0634B18000A603F'))
The workflow. Still very simple. It is supposed to have two more invoke api steps before any human steps (if somthing goes wrong with the upload)
the database package works fine when called from pl/sql developer with the same parameters.
I have not definede any “Task definitons”. Those are for human steps?
Tried starting it from a process in a form also:
Some debug information. The last select, before red text returns the data to process.
