Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> UTL_FILE PACKAGE PROBLEM
Here is my problem.
I'm trying to write a file out to diak using the utl_file package. I keep
getting the invalid_path error raised in the exception section of my
procedure. The path is valid so why can't Oracle find it? I am passing in
the trailing \ in the directory portion of the
" lr_file_handle := utl_file.fopen(lc_dir_path, lc_file_name,
lc_write_mode); "
I'm out of Ideas.
Any help would be greatly appreciated.
EXCEPTION
WHEN utl_file.invalid_path THEN
dbms_output.put_line('ERROR RAISED invalid_path');
WHEN utl_file.invalid_mode THEN
dbms_output.put_line('ERROR RAISED invalid_mode');
WHEN utl_file.invalid_filehandle THEN
dbms_output.put_line('ERROR RAISED invalid_filehandle');
WHEN utl_file.invalid_operation THEN
dbms_output.put_line('ERROR RAISED invalid_operation');
WHEN utl_file.read_error THEN
dbms_output.put_line('ERROR RAISED read_error');
WHEN utl_file.write_error THEN
dbms_output.put_line('ERROR RAISED write_error');
WHEN utl_file.internal_error THEN
dbms_output.put_line('ERROR RAISED internal_error');
utl_file.fclose(lr_file_handle);
TIA, Terry Received on Thu Aug 05 1999 - 16:36:41 CDT