directory path from full path

CREATE OR REPLACE FUNCTION get_dir_path (p_file IN VARCHAR2) RETURN varchar2 IS v_dir_path VARCHAR2(1000); BEGIN /* || This Function returns a varchar2 string of the directory path of the file name. — not including trailing slash. || Written by: Daniel Coe