How does we customize error messages in Oracle Forms

We can set the message level using the system variable SYSTEM.MESSAGE_LEVEL or trap errors using the ON-ERROR or ON-MESSAGE in Form level triggers.

MESSAGE_LEVEL:



0     : Default value. All types of messages from the other levels of severity.
5     : Reaffirms an obvious condition.
10   : Indicates that the operator has made a procedural mistake.



15   : Declares that the operator is attempting to perform a function for which the form is not designed.
20   : Indicates a condition where the operator cannot continue an intended action due to a problem with a trigger or another outstanding condition.
25   : Indicates a condition that could result in the form performing incorrectly.
>25 : Indicates a message severity level that you cannot suppress via the SYSTEM.MESSAGE_LEVEL system variable.


Examples:

:SYSTEM.MESSAGE_LEVEL := '25';
COMMIT;
:SYSTEM.MESSAGE_LEVEL := '0';


/* For suppressing FRM-40100: At first record. */
:SYSTEM.MESSAGE_LEVEL := '5';


FIRST_RECORD;
:SYSTEM.MESSAGE_LEVEL := '0';


/* For suppressing FRM-40350: Query caused no records to be retrieved. */
:SYSTEM.MESSAGE_LEVEL := '5';
EXECUTE_QUERY;
:SYSTEM.MESSAGE_LEVEL := '0'

Comments

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

How to Create Packages in Oracle Database using TOAD for Oracle

How to create a Simple Scheduler Job in Oracle Database using Toad