23.13 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 23-7 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;
See Also:
Parent topic: APEX_DEBUG