Re: UTL_FILE PACKAGE PROBLEM

The path must exists, and must be listed in init.ora (utl_file_dir=path). Lets look that this path is case sensitive, also under Windows NT! All of this do you have correct ?

Rafal Czekala (czekala_at_real.pl)
Oracle DBA

In article <7od083$s2a$3_at_news.chorus.net>,   "Terry Anderson" <tande922_at_hotmail.com> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 06 1999 - 06:45:54 CDT