utl_file

From: HornDog <brianbom_at_mail.pacifier.com>
Date: 1997/07/09
Message-ID: <5pva4h$4k0$1@news.pacifier.com>#1/1

I was trying the canned oracle package utl_file today and trying to open and read a ascii file on a Sun Solaris system. I wrote some code that looked something like follows and I keep getting an invalid_path exception. Any suggestions would be appreciated!

DECLARE
        filehandle utl_file.file_type;
BEGIN
        filehandle := utl_file.fopen ('/export/post', 'test.file', 'r'); EXCEPTION

	WHEN utl_file.invalid_path THEN
		dbms_output.put_line ('invalid_path');
	WHEN utl_file.invalid_mode THEN
		dbms_output.put_line ('invalid_mode');
	WHEN utl_file.invalid_operation THEN
		dbms_output.put_line ('invalid_operation');

END; I looked at the obvious, the input file IS there???

-- 


-------------------------------------------------------

Pacifier Online Data Service Dialup SLIP/PPP User
To register: (360) 693-0325 or telnet pods.pacifier.com


-------------------------------------------------------

Received on Wed Jul 09 1997 - 00:00:00 CDT