get directory name

CREATE OR REPLACE FUNCTION get_dir_name (p_file IN VARCHAR2) RETURN varchar2 IS v_dir_name VARCHAR2(1000); BEGIN /* || This Function returns a varchar2 string of the name of folder above the file name. || Written by: Daniel Coe || Date: 10/09/2002 */