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

How to create Oracle stored Procedures using TOAD for Oracle

Create Tables in Oracle Database using TOAD

How to Create Packages in Oracle Database using TOAD for Oracle