Home/ Questions/Q 2524
In Process

vinish.ai Latest Questions

  • 2
  • 2
Asked: 2020-10-16T11:29:09+00:00

Capture database Error and Amend it in Oracle Apex

  • 2
  • 2

Hi Vinish,

If any validation which fire either it from database trigger or constrains check then how we can capture and show property message.

As most of the database errors appear like ’033-ORA-NOT VALID CONDITION’ How to capture this error and make it proper so user can easily understand.

Thanks.

oracle apex
Share
Leave an answer

Leave an answer

Browse

1 Answer

  1. You will have to catch the specific errors and then display the custom message using apex.error API method in a process. Below is an example:

    The following PL/SQL code will catch the unique constraint error and will give the user-defined message:

    Begin
   -- your pl/sql code

Exception 
   when dup_val_on_index then
apex_error.add_error (
p_message => 'Customer id should be unique',
p_additional_info => 'Errors',
p_display_location => apex_error.c_inline_in_notification);
raise;
   when others then
apex_error.add_error (
p_message => 'An error occurred.',
p_additional_info => 'Errors',
p_display_location => apex_error.c_inline_in_notification);
raise;     
End;

    You can check the list of pre-defined errors using this link.

    You can also check the following link to learn how to log errors in the error log table whenever an error occurs.

    Handle errors and log into a table