function login

function login(
    p_host in varchar2,
    p_port in varchar2,
    p_user in varchar2,
    p_pass in varchar2,
    p_timeout in number:=null
) return utl_tcp.connection

function get_passive

function get_passive(
    p_conn in out nocopyutl_tcp.connection
) return utl_tcp.connection

procedure logout

procedure logout(
    p_conn in out nocopyutl_tcp.connection,
    p_reply in boolean:=true
)

procedure send_command

procedure send_command(
    p_conn in out nocopyutl_tcp.connection,
    p_command in varchar2,
    p_reply in boolean:=true
)

procedure get_reply

procedure get_reply(
    p_conn in out nocopyutl_tcp.connection
)

function get_local_ascii_data

function get_local_ascii_data(
    p_dir in varchar2,
    p_file in varchar2
) return clob

function get_local_binary_data

function get_local_binary_data(
    p_dir in varchar2,
    p_file in varchar2
) return blob

function get_remote_ascii_data

function get_remote_ascii_data(
    p_conn in out nocopyutl_tcp.connection,
    p_file in varchar2
) return clob

function get_remote_binary_data

function get_remote_binary_data(
    p_conn in out nocopyutl_tcp.connection,
    p_file in varchar2
) return blob

procedure put_local_ascii_data

procedure put_local_ascii_data(
    p_data in clob,
    p_dir in varchar2,
    p_file in varchar2
)

procedure put_local_binary_data

procedure put_local_binary_data(
    p_data in blob,
    p_dir in varchar2,
    p_file in varchar2
)

procedure put_remote_ascii_data

procedure put_remote_ascii_data(
    p_conn in out nocopyutl_tcp.connection,
    p_file in varchar2,
    p_data in clob
)

procedure put_remote_binary_data

procedure put_remote_binary_data(
    p_conn in out nocopyutl_tcp.connection,
    p_file in varchar2,
    p_data in blob
)

procedure get

procedure get(
    p_conn in out nocopyutl_tcp.connection,
    p_from_file in varchar2,
    p_to_dir in varchar2,
    p_to_file in varchar2
)

procedure put

procedure put(
    p_conn in out nocopyutl_tcp.connection,
    p_from_dir in varchar2,
    p_from_file in varchar2,
    p_to_file in varchar2
)

procedure get_direct

procedure get_direct(
    p_conn in out nocopyutl_tcp.connection,
    p_from_file in varchar2,
    p_to_dir in varchar2,
    p_to_file in varchar2
)

procedure put_direct

procedure put_direct(
    p_conn in out nocopyutl_tcp.connection,
    p_from_dir in varchar2,
    p_from_file in varchar2,
    p_to_file in varchar2
)

procedure help

procedure help(
    p_conn in out nocopyutl_tcp.connection
)

procedure ascii

procedure ascii(
    p_conn in out nocopyutl_tcp.connection
)

procedure binary

procedure binary(
    p_conn in out nocopyutl_tcp.connection
)

procedure list

procedure list(
    p_conn in out nocopyutl_tcp.connection,
    p_dir in varchar2,
    p_list out t_string_table
)

procedure nlst

procedure nlst(
    p_conn in out nocopyutl_tcp.connection,
    p_dir in varchar2,
    p_list out t_string_table
)

procedure rename

procedure rename(
    p_conn in out nocopyutl_tcp.connection,
    p_from in varchar2,
    p_to in varchar2
)

procedure delete

procedure delete(
    p_conn in out nocopyutl_tcp.connection,
    p_file in varchar2
)

procedure mkdir

procedure mkdir(
    p_conn in out nocopyutl_tcp.connection,
    p_dir in varchar2
)

procedure rmdir

procedure rmdir(
    p_conn in out nocopyutl_tcp.connection,
    p_dir in varchar2
)

procedure convert_crlf

procedure convert_crlf(
    p_status in boolean
)

varray t_string_table

type t_string_table is varray of varchar2(32767)