Hi,
I am working with APX 5.0.0.
I have the following procedure inside the PL/SQL code of a Dynamic Action that fires on Page Load::
create or replace procedure remove_something
is
v_sql varchar2(1000) := null;
begin
v_sql := 'delete from coa d where d.coa_id = 0';
execute immediate v_sql;
exception
when others then
htp.p ('<b>[ERROR] Nothing to delete.</b>');
end;
/
When I call the page (the page that contains the DA with the above PL/SQL code), no mesage appear (I mean: "[ERROR] Nothing to delete.").
How can I display on a friendly way a message issued from the exception block of a procedure in APEX?
Thanks by advance for any tip.
Kind Regards.