Oracle® Forms System Variable

Suppress Forms Messages




SYSTEM.MESSAGE_LEVEL stores one of the following message severity levels: 0, 5, 10, 15, 20, or 25. The default value is 0. SYSTEM.MESSAGE_LEVEL can be set to either a character string or a number. The values assigned can be any value between 0 and 25, but values lower than 0 or higher than 25 will generate an error. During a Runform session, Oracle® Forms suppresses all messages with a severity level that is the same or lower (less severe) than the indicated severity level. Assign a value to the SYSTEM.MESSAGE_LEVEL system variable with standard PL/SQL syntax: :System.Message_Level := value; The legal values for SYSTEM.MESSAGE_LEVEL are 0, 5, 10, 15, 20, and 25. Oracle® Forms does not suppress prompts or vital error messages, no matter what severity level you select.


Assume that you want Oracle® Forms to display only the most severe messages (level 25).

The following Pre-Form trigger suppresses all messages at level 20 and below (what would be a bad practice at all).

:System.Message_Level := '20';

Oracle® System.message_level Forms System Variable

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle