Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

User-friendly PL/SQL execptions renderen in PL/SQL Dynamic Action

LauryOct 3 2016 — edited Oct 6 2016

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2016
Added on Oct 3 2016
9 comments
506 views