Hi All,
Using APEX 5.1.3 with universal theme. I have a process based on a PLSQL code below. The process is triggered from a page by click of a button. The page has one button and two fields (i.e. 'process number' and one display field only 'orders')
begin
if :P3_PROCESS_NUM = 1 then
select count(*) into :P3_ORDER_NUM from process where process_num = '1';
if :P3_ORDER_NUM = 0 then
trigger_process;
select count(*) into :P3_ORDER_NUM from process where process_num = '1';
else
APEX_ERROR.ADD_ERROR(p_message => 'The process was already created.', p_display_location => apex_error.c_inline_in_notification);
end if;
end if;
end;
The issue is when the validation error is triggered, it shows the message ' Process was already created', all good. But I also want the value in P3_ORDER_NUM which is in session to show up in the order field irrespective of error or not. Currently only shown if no errors.
Secondly, i want the values in the sessions (i.e. P3_PROCESS_NUM, P3_ORDER_NUM) to reset when user navigates to other page and comes back.
Thanks