Using files in Oracle

From: eoin mcquillan <eoin.mcquillan_at_bt.com>
Date: 2000/03/08
Message-ID: <8a5kk9$hc2$1@pheidippides.axion.bt.co.uk>#1/1

I'm using Oracle Application Server 4.0.8.1 with Oracle Enterprise Edition 8.0.5 on Windows NT 4.0. In one of my procedures I'm trying to use a file as a mailing list I'm only at a test stage but when I use the two statements:

mail__file := UTL_FILE.FOPEN('d:\orant','dummy.txt','A'); UTL_FILE.FCLOSE(mail_file);

This does not come up with any errors in the compiler but when executed in the browser I get the following:

OWS-05101: Execution failed due to Oracle error 6510
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 98
ORA-06512: at "SYS.UTL_FILE", line 157
ORA-06512: at "EMCQUILLAN.TESTFILE", line 21
ORA-06512: at line 5

I have heard that I may have to use a utl_directory command but have no documentation on what this does.
Can anybody give me any ideas?
Thanks
Eoin McQuillan Received on Wed Mar 08 2000 - 00:00:00 CST