sylk_util_pkg package

Functions, procedures

procedure show

procedure show(
    p_file in utl_file.file_type,
    p_query in varchar2,
    p_parm_names in owasylkarray default owasylkarray(),
    p_parm_values in owasylkarray default owasylkarray(),
    p_sum_column in owasylkarray default owasylkarray(),
    p_max_rows in number default 10000,
    p_show_null_as in varchar2 default null,
    p_show_grid in varchar2 default YES,
    p_show_col_headers in varchar2 default YES,
    p_font_name in varchar2 default Courier New,
    p_widths in owasylkarray default owasylkarray(),
    p_titles in owasylkarray default owasylkarray(),
    p_strip_html in varchar2 default YES
)

procedure show

procedure show(
    p_file in utl_file.file_type,
    p_cursor in integer,
    p_sum_column in owasylkarray default owasylkarray(),
    p_max_rows in number default 10000,
    p_show_null_as in varchar2 default null,
    p_show_grid in varchar2 default YES,
    p_show_col_headers in varchar2 default YES,
    p_font_name in varchar2 default Courier New,
    p_widths in owasylkarray default owasylkarray(),
    p_titles in owasylkarray default owasylkarray(),
    p_strip_html in varchar2 default YES
)

Types

varray owasylkarray

type owasylkarray is varray of varchar2(2000)