zip_util_pkg package

function get_file_list(
    p_dir in varchar2,
    p_zip_file in varchar2,
    p_encoding in varchar2:=null
) return t_file_list

function get_file_list(
    p_zipped_blob in blob,
    p_encoding in varchar2:=null
) return t_file_list

function get_file(
    p_dir in varchar2,
    p_zip_file in varchar2,
    p_file_name in varchar2,
    p_encoding in varchar2:=null
) return blob

function get_file(
    p_zipped_blob in blob,
    p_file_name in varchar2,
    p_encoding in varchar2:=null
) return blob

procedure add_file(
    p_zipped_blob in out blob,
    p_name in varchar2,
    p_content in blob
)

procedure finish_zip(
    p_zipped_blob in out blob
)

procedure save_zip(
    p_zipped_blob in blob,
    p_dir in varchar2,
    p_filename in varchar2
)

type t_file_list is varray of clob