To be sure that there is a bug on the apex side I tried it on the simplest solution,
I created the pl/sql action and set it on create event for the task definition. The whole code looks like this:
insert into TMP_LOGS
values('123');
The error I'm getting doesn't say me anything:
Exception in "do_create_task":
Error Stack: ORA-06510: PL/SQL: nieobsługiwany zdefiniowany przez użytkownika wyjątek
ORA-06512: przy "APEX_240100.WWV_FLOW_APPROVAL", linia 2314
ORA-06512: przy "APEX_240100.WWV_FLOW_APPROVAL", linia 2314
Backtrace: ORA-06512: przy "APEX_240100.WWV_FLOW_APPROVAL", linia 2314
ORA-06512: przy "APEX_240100.WWV_FLOW_APPROVAL", linia 2314
When I change the event in the action definition from create to the task completion, then it works without any problems. After task is approved new record shows in tmp_logs table and the process proceeds.
To be sure that there is a bug on the apex side I tried it on the simplest solution,
I created the pl/sql action and set it on create event for the task definition. The whole code looks like this:
insert into TMP_LOGS
values('123');
The error I'm getting doesn't say me anything:
Exception in "do_create_task":
Error Stack: ORA-06510: PL/SQL: nieobsługiwany zdefiniowany przez użytkownika wyjątek
ORA-06512: przy "APEX_240100.WWV_FLOW_APPROVAL", linia 2314
ORA-06512: przy "APEX_240100.WWV_FLOW_APPROVAL", linia 2314
Backtrace: ORA-06512: przy "APEX_240100.WWV_FLOW_APPROVAL", linia 2314
ORA-06512: przy "APEX_240100.WWV_FLOW_APPROVAL", linia 2314
When I change the event in the action definition from create to the task completion, then it works without any problems. After task is approved new record shows in tmp_logs table and the process proceeds.