LOG_MESSAGE Procedure [Deprecated]

This procedure logs a debug message.

Note:

Instead of this procedure, use "ERROR Procedure", "WARN Procedure", "MESSAGE Procedure", "INFO Procedure", "ENTER Procedure", or "TRACE Procedure"

Syntax

APEX_DEBUG.LOG_MESSAGE ( 
    p_message IN VARCHAR2 DEFAULT NULL, 
    p_enabled IN BOOLEAN DEFAULT FALSE, 
    p_level IN T_LOG_LEVEL DEFAULT C_LOG_LEVEL_APP_TRACE );

Parameters

Table 7-6 describes parameters available for the APEX_DEBUG.LOG_MESSAGE procedure.

Table 7-6 APEX_DEBUG.LOG_MESSAGE Procedure Parameters

Parameter	Description
`p_message`	The debug message with a maximum length of 1000 bytes.
`p_enabled`	Messages are logged when logging is enabled, setting a value of true enables logging.
`p_level`	Identifies the level of the log message where 1 is most important and 9 is least important. This is an integer value.

Example

This example shows how to enable debug message logging for 1 and 2 level messages and display a level 1 message showing a variable value. Note, the p_enabled parameter need not be specified, as debugging has been explicitly enabled and the default of false for this parameter respects this enabling.

DECLARE
    l_value varchar2(100) := 'test value';
BEGIN
    APEX_DEBUG.ENABLE (p_level => 2);
 
APEX_DEBUG.LOG_MESSAGE(
    p_message => 'l_value = ' || l_value,
    p_level => 1 );
 
END;