using files in Oracle
From: eoin mcquillan <eoin.mcquillan_at_bt.com>
Date: Wed, 8 Mar 2000 13:25:56 -0800
Message-ID: <8a5kit$hbf$1_at_pheidippides.axion.bt.co.uk>
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:
Date: Wed, 8 Mar 2000 13:25:56 -0800
Message-ID: <8a5kit$hbf$1_at_pheidippides.axion.bt.co.uk>
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 - 22:25:56 CET