Databases Reference
In-Depth Information
LOG_MESSAGE Procedure
This procedure allows the developer to emit debug messages from within either APEX anonymous
blocks or stored packages and procedures called from APEX.
Syntax
procedure log message (
p message in varchar2 default null,
p enabled in boolean default false,
p level in number default 7);
Parameters
p_message: Message to be logged up to 4000 characters
p_enabled: Whether to log the message regardless of whether Debug mode is enabled. Pass one of
the following values:
TRUE: Message will be logged regardless of debug mode.
FALSE: Message will only be logged if debug mode is enabled.
p_level: Identifies the level of the log message.
Usage Notes
Level 1 is the most important.
Level 7 is the least important.
When using within stored PL/SQL program units that might be called outside of the context of
APEX, always set P_ENABLED to FALSE. Failing to do so will result in an error, as the APEX
SECURITY GROUP ID will not be set.
LOG_LONG_MESSAGE Procedure
This procedure allows the developer to emit debug messages larger than 4000 characters from within
either APEX anonymous blocks or stored packages and procedures called from APEX.
Syntax
procedure log long message (
p message in varchar2 default null,
p enabled in boolean default false,
p level in number default 7);
