const g_os_windows

g_os_windows constant varchar2(1):='w'

operating system types

const g_os_unix

g_os_unix constant varchar2(1):='u'

const g_dir_sep_win

g_dir_sep_win constant varchar2(1):='\'

const g_dir_sep_unix

g_dir_sep_unix constant varchar2(1):='/'

const g_file_ext_sep

g_file_ext_sep constant varchar2(1):='.'

const g_file_mode_append_text

g_file_mode_append_text constant varchar2(1):='a'

file open modes

const g_file_mode_append_byte

g_file_mode_append_byte constant varchar2(2):='ab'

const g_file_mode_read_text

g_file_mode_read_text constant varchar2(1):='r'

const g_file_mode_read_byte

g_file_mode_read_byte constant varchar2(2):='rb'

const g_file_mode_write_text

g_file_mode_write_text constant varchar2(1):='w'

const g_file_mode_write_byte

g_file_mode_write_byte constant varchar2(2):='wb'

var g_file_name_def

g_file_name_def varchar2(2000)

var subtype

subtype t_file_nameisg_file_name_def%type

var g_file_ext_def

g_file_ext_def varchar2(50)

var subtype

subtype t_file_extisg_file_ext_def%type

var g_dir_sep_def

g_dir_sep_def varchar2(1)

var subtype

subtype t_dir_sepisg_dir_sep_def%type

function resolve_filename

function resolve_filename(
    p_dir in varchar2,
    p_file_name in varchar2,
    p_os in varchar2:=g_os_windows
) return varchar2

resolve filename

function extract_filename

function extract_filename(
    p_file_name in varchar2,
    p_os in varchar2:=g_os_windows
) return varchar2

extract filename

function get_file_ext

function get_file_ext(
    p_file_name in varchar2
) return varchar2

get file extension

function strip_file_ext

function strip_file_ext(
    p_file_name in varchar2
) return varchar2

strip file extension

function get_filename_str

function get_filename_str(
    p_str in varchar2,
    p_extension in varchar2:=null
) return varchar2

get filename string (no whitespace)

function get_blob_from_file

function get_blob_from_file(
    p_directory_name in varchar2,
    p_file_name in varchar2
) return blob

get blob from file

function get_clob_from_file

function get_clob_from_file(
    p_directory_name in varchar2,
    p_file_name in varchar2
) return clob

get clob from file

procedure save_blob_to_file

procedure save_blob_to_file(
    p_directory_name in varchar2,
    p_file_name in varchar2,
    p_blob in blob
)

save blob to file

procedure save_clob_to_file

procedure save_clob_to_file(
    p_directory_name in varchar2,
    p_file_name in varchar2,
    p_clob in clob
)

save clob to file

procedure save_clob_to_file_raw

procedure save_clob_to_file_raw(
    p_directory_name in varchar2,
    p_file_name in varchar2,
    p_clob in clob
)

save clob to file (raw)

function file_exists

function file_exists(
    p_directory_name in varchar2,
    p_file_name in varchar2
) return boolean

does file exist?

function fmt_bytes

function fmt_bytes(
    p_bytes in number
) return varchar2

format bytes