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!

Error Handling in APEX

user5108636Apr 17 2018 — edited Apr 17 2018

Hi All,

   Using APEX 5.1.2, I have a process based on a PLSQL procedure. I want to do customexception handling for no data found. Below snippet code

  EXCEPTION

    WHEN NO_DATA_FOUND THEN

       apex_application.g_print_success_message := 'No data found for processing.';

       --APEX_ERROR.ADD_ERROR(p_message => 'No data found for processing.', p_display_location => apex_error.c_inline_in_notification);

    WHEN OTHERS THEN

       ROLLBACK;

   END test;

However, this does not seems to throw the custom message 'No data found for processing'

Please advise.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 15 2018
Added on Apr 17 2018
3 comments
279 views