How to Suppress Error Message in Oracle Forms?

How to Suppress Error Message in Oracle Forms?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • Below I am giving two examples to suppress the error messages in Oracle Forms, the first example is to suppress all the error messages and the second example is to suppress all the error messages but handle a specific error and give a custom message in Oracle Forms.

    Suppress all The Error Messages in Oracle Forms

    Write an ON-ERROR trigger at form level as shown below:

    Begin
   Null;
   /* it will simply do nothing on any error.*/
End;

    Ignore All Error Message But Handle FRM-40202 (Field must be entered.)

    Write an ON-ERROR trigger at form level as shown below:

    Declare
   error_item varchar2(50);
   curr_item_label varchar2(100);
Begin
   error_item := :system.trigger_item;
   if error_type = 'FRM' and error_code = 40202 then
      message(curr_item_label || ' cannot be left blank.');
      raise form_trigger_failure;
   else
      Null;
      -- ignore other errors
   end if; 
end;

    See also:

    • Know How And When To Use System.Message_Level To Control Messages In Oracle Forms
    • Writing On-Error Trigger In Oracle Forms
    • An Example of On-Error Trigger in Oracle Forms