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 PROBLEM

UTL_FILE PACKAGE PROBLEM

From: Terry Anderson <tande922_at_hotmail.com>
Date: Thu, 5 Aug 1999 16:36:41 -0500
Message-ID: <7od083$s2a$3@news.chorus.net>


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

Original text of this message

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