23.22 WARN Procedure

This procedure logs messages at level c_log_level_warn.

Syntax

APEX_DEBUG.WARN (
    p_message       IN VARCHAR2,
    p0              IN VARCHAR2     DEFAULT NULL,
    p1              IN VARCHAR2     DEFAULT NULL,
    p2              IN VARCHAR2     DEFAULT NULL,
    p3              IN VARCHAR2     DEFAULT NULL,
    p4              IN VARCHAR2     DEFAULT NULL,
    p5              IN VARCHAR2     DEFAULT NULL,
    p6              IN VARCHAR2     DEFAULT NULL,
    p7              IN VARCHAR2     DEFAULT NULL,
    p8              IN VARCHAR2     DEFAULT NULL,
    p9              IN VARCHAR2     DEFAULT NULL,
    p_max_length    IN PLS_INTEGER  DEFAULT 1000 )

Parameters

Parameter Description
p_message The debug message. Occurrences of % are replaced by p0 to p19, as in utl_lms.format_message and C's sprintf. Occurrences of %% represent the special character %. Occurrences of %<n> are replaced by p<n>.
p0 through p9 Substitution strings for % placeholders.
p_max_length The p<n> values are truncated to this length. The tilde (~) character is appended to indicate that the original value exceeded this length.

Example

This example shows how to use APEX_DEBUG.WARN to log highly important data in the debug log.

apex_debug.warn('Soft constraint %s violated: %s', 4711, sqlerrm);