Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using files in Oracle

Re: Using files in Oracle

From: Dennis Havermans <dhavermans_at_transfer-solutions.com>
Date: 2000/03/09
Message-ID: <8a8d4q$86u$1@porthos.nl.uu.net>#1/1

Hi,

You need to set the UTL_FILE_DIR parameter in your init.ora. This will make a directory
available which will be used for PL/SQL IO.

Dennis Havermans
Transfer DBA Solutions

www.transfer-solutions.com

eoin mcquillan <eoin.mcquillan_at_bt.com> wrote in message news:8a5kk9$hc2$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 Thu Mar 09 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US