Re: UTL_FILE: Invalid Path Exception

Tom Kytes suggestions seem the more likely. Also, bear in mind that UTL_FILE is a server side file utility and not client side so the c:\temp has to exist on the server machine that Oracle is sitting on.

M

"Gerald Gruber" <gru_at_trench.at> wrote in message news:<9s82cj$liq$1_at_newsreader1.netway.at>...
> Hi,
> I started working on Oracle and PL/SQL some weeks ago. Now I try to work
> with OS-Files using the UTL_FILE-Package. But I have a problem to open the
> data source. I always get the "Invalid Path" exception and I don´t know why?
>
> I run the programm from SQL*Plus on a Windows2000 Server.
>
> Here is the simple program:
>
> DECLARE
> v_kanal utl_file.file_type;
> v_puffer varchar2(255);
>
> BEGIN
> v_kanal := utl_file.fopen('c:\temp','eingabe.dat','r');
> LOOP
> BEGIN
> utl_file.get_line(v_kanal,v_puffer);
> dbms_output.put_line(v_puffer);
> EXCEPTION
> when no_data_found then exit;
> END;
> END LOOP;
> utl_file.fclose(v_kanal);
> EXCEPTION
> when utl_file.invalid_path
> then dbms_output.put_line('Invalid Pfad'); -- progam always ends here!
> when utl_file.invalid_operation
> then dbms_output.put_line('Invalid Operation');
>
> END;
>
> And this is my INITgru.ORA File:
>
> utl_file_dir = *
> IFILE='C:\Oracle\admin\gru\pfile\init.ora'
>
> Thanx for any help
>
> Gerald
Received on Wed Nov 07 2001 - 10:24:54 CET