Hi When i am running the below script
i am gettin gerror like Invalid directory path.
Can you please help me out how to check the path by using dbms_ouput.
error : ORA-29280: invalid directory path
ORA-06512: at line 34
DECLARE
l_out_file UTL_FILE.file_type;
g_convert_crlf BOOLEAN := TRUE;
P_DATA VARCHAR2(32767);
l_buffer VARCHAR2(32767);
l_amount BINARY_INTEGER := 32767;
l_pos INTEGER := 1;
p_file varchar2(2345);
P_DIR VARCHAR2(34);
l_clob_len INTEGER;
BEGIN
l_clob_len := DBMS_LOB.getlength(p_data);
dbms_output.put_line (p_data);
l_out_file := UTL_FILE.fopen(p_dir, p_file, 'w', 32767);
WHILE l_pos < l_clob_len LOOP
DBMS_LOB.read (p_data, l_amount, l_pos, l_buffer);
IF g_convert_crlf THEN
l_buffer := REPLACE(l_buffer, CHR(13), NULL);
END IF;
UTL_FILE.put(l_out_file, l_buffer);
UTL_FILE.fflush(l_out_file);
l_pos := l_pos + l_amount;
END LOOP;
UTL_FILE.fclose(l_out_file);
EXCEPTION
WHEN OTHERS THEN
IF UTL_FILE.is_open(l_out_file) THEN
UTL_FILE.fclose(l_out_file);
END IF;
RAISE;
END;