UTL_FILE Package
Date: 1999/08/05
Message-ID: <7od081$s2a$2_at_news.chorus.net>#1/1
Here is my problem.
When I try and write a file out to disk in my procedure the utl_file.invalid_path exception keeps getting raised. The directory path exists so why can't Oracle find it? I recently installed the 7.3.4 patch and was at 7.3.3. I re-ran the catalog, catproc, and catexp procedures and re-ran the utlfile package as well after the problem started. I'm at a loss. Below is the exception portion of the code.
Any help would be 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 - 00:00:00 CEST