LOG_MESSAGE Procedure (Deprecated)

23.13 LOG_MESSAGE Procedure (Deprecated)

This procedure logs a debug message.

Note:

This API is deprecated and will be removed in a future release.

Instead of this procedure, use the following:

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

Parameter	Description
`p_message`	The debug message with a maximum length of 1,000 bytes.
`p_enabled`	Messages are logged when logging is enabled. `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 enables debug message logging for level 1 and 2 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;