debug_pkg

Functions, procedures

procedure debug_off 

procedure debug_off

turn off debugging

procedure debug_on 

procedure debug_on

turn on debugging

procedure print 

procedure print(
    p_msg in varchar2
)

print debug information

procedure print 

procedure print(
    p_msg in varchar2,
    p_value in varchar2
)

print debug information (name/value pair)

procedure print 

procedure print(
    p_msg in varchar2,
    p_value in number
)

print debug information (number)

procedure print 

procedure print(
    p_msg in varchar2,
    p_value in date
)

print debug information (date)

procedure print 

procedure print(
    p_msg in varchar2,
    p_value in boolean
)

print debug information (boolean)

procedure print 

procedure print(
    p_refcursor in sys_refcursor,
    p_null_handling in number:=0
)

print debug information (ref cursor)

procedure print 

procedure print(
    p_xml in xmltype
)

print debug information (xmltype)

procedure print 

procedure print(
    p_clob in clob
)

print debug information (clob)

procedure printf 

procedure printf(
    p_msg in varchar2,
    p_value1 in varchar2:=null,
    p_value2 in varchar2:=null,
    p_value3 in varchar2:=null,
    p_value4 in varchar2:=null,
    p_value5 in varchar2:=null,
    p_value6 in varchar2:=null,
    p_value7 in varchar2:=null,
    p_value8 in varchar2:=null
)

print debug information (multiple values)

function get_fdate 

function get_fdate(
    p_date in date
) return varchar2

get date string in debug format

procedure set_info 

procedure set_info(
    p_action in varchar2,
    p_module in varchar2:=null
)

set session info (will be available in v$session)

procedure clear_info 

procedure clear_info

clear session info