PL/SQL FILE I/O

From: Praveen Shettigar <praveen_at_swt.edu>
Date: Fri, 31 Mar 2000 18:46:31 -0600
Message-ID: <38E546E7.F728D5D2@swt.edu>

Hello,

I am trying to write a PL/SQL program that will read the input data from a file and insert tuples into tables.

My code :--

set serveroutput on
clear buffer;

DECLARE
--I/O Variables

 in_file_handle       utl_file.file_type;
 out_file_handle     utl_file.file_type;
 file_path         varchar2(80) := '/home/grads/shettiga/ins';

 in_file_name varchar2(40) := 'insert.txt';  out_file_name varchar2(40) := 'output.txt';

BEGIN

 dbms_output.enable(30000);
 dbms_output.put_line('begin the program now:');
 dbms_output.new_line;

 in_file_handle := utl_file.fopen(file_path, in_file_name, 'r');

 dbms_output.put_line ('Now the input file has been opened');

 out_file_handle := utl_file.fopen(file_path, out_file_name, 'a');  dbms_output.put_line ('Output file has been opened');

EXCEPTION
 WHEN no_data_found THEN

     dbms_output.put_line('END OF FILE REACHED');

 WHEN utl_file.invalid_path THEN

     dbms_output.put_line('INVALID PATH');

 WHEN OTHERS THEN
  begin
    ROLLBACK;
    dbms_output.put_line('Something Wrong. TERMINATING....');   end;

END;
/

After running the program
the output -

begin the program now:
INVALID PATH I checked the file name and the file location and i found that they represent a legal filename on the system, and the directory is also accessible.
Then why i am getting such an error??

thankyou
Praveen Received on Fri Mar 31 2000 - 18:46:31 CST