UTL_FILE: Invalid Path Exception

From: Gerald Gruber <gru_at_trench.at>
Date: Tue, 6 Nov 2001 08:10:10 +0100
Message-ID: <9s82cj$liq$1_at_newsreader1.netway.at>

Hi,
[Quoted] [Quoted] 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 Tue Nov 06 2001 - 08:10:10 CET