ftp_util_pkg

Functions, procedures

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
)

Types

varray t_string_table 

type t_string_table is varray of varchar2(32767)