Re: Question on utl_file

From: Clifton L. McLellan <mclellan_at_ReactionDesign.com>
Date: 1997/05/20
Message-ID: <01bc64c6$9c031080$e7c809c0_at_ktaadn>#1/1


I am currently using the following:

[Quoted]     fd := UTL_FILE.FOPEN( 'd:\dir1\dir2\dir3\Queries', 'newfile', 'w' );

where the directory name is cut and pasted to the instance init.ora file. Note that 'a' does not seem to work. I discovered that the very hard way.

-- 

Hope this helps,
Clifton L. McLellan


Peter Adams <padams_at_sul.stanford.edu> wrote in article
<3380E55F.6E94A8F_at_sul.stanford.edu>...

> Are there any tricks to get utl_file.fopen(dir,file,mode)
> to work on NT from a stored procedure? I keep getting an
> invalid path exception. I modified the initorcl.ora file
> with the utl_file_dir parameter to read c:\temp As arguments
> to fopen I am passing the directory with the additional
> delimiter (c:\temp\), plus the file name (x.txt) and the 'R'
> argument for read only. This is all happening within my NT
> box.
>
> TIA,
>
> Pete
>
> --
> Peter Adams
> Sr Systems Developer
> Stanford University Libraries
> vc: 415-725-7909
> fx: 415-725-4902
> em: padams_at_sulmail.stanford.edu
> http://www-sul.stanford.edu
>
>
Received on Tue May 20 1997 - 00:00:00 CEST

Original text of this message