23.20 TOCHAR Function

This procedure converts a BOOLEAN to a VARCHAR2.

Syntax

APEX_DEBUG.TOCHAR (
    p_value IN BOOLEAN )
    RETURN VARCHAR2;

Parameters

Parameter	Description
p_value	A BOOLEAN 0 or 1 that is converted to FALSE or TRUE respectively.

Example

This example shows how to use the APEX_DEBUG.TOCHAR function to convert boolean values to varchar2, so they can be passed to the other debug procedures.

DECLARE
    l_state boolean;
BEGIN
    ....
    apex_debug.info('Value of l_state is %s', apex_debug.tochar(l_state));
    ....
END;