18.20 TOCHAR Function

This procedure converts a BOOLEAN to a VARCHAR2.

Syntax

APEX_DEBUG.TOCHAR ( 
    p_value    IN BOOLEAN ) 
    RETURN VARCHAR2; 

Parameters

Table 18-14 APEX_DEBUG.TOCHAR Function Parameters

Parameter	Description
p_value	A BOOLEAN 0or 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;