Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> UTL_FILE Package

UTL_FILE Package

From: Terry Anderson <tande922_at_hotmail.com>
Date: Thu, 5 Aug 1999 16:29:45 -0500
Message-ID: <7od081$s2a$2@news.chorus.net>


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 - 16:29:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US