This procedure logs a debug message.
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 |
---|---|
|
The debug message with a maximum length of 1000 bytes. |
|
Messages are logged when logging is enabled, setting a value of true enables logging. |
|
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;