Re: Procedure "fopen" in the utl_file package

I am just curious. If I am trying to use this UTL_FILE package on unix system and the directory is NFS mounted does it effect in any way ?

sm wrote:

> (a) Set the UTL_FILE_DIR init.ora parameter to either a * (asterisk)
> to specify all dirs or the list of valid dirs. Reason security.
>
> (b) You can use UTL_FILE package to work on files lying on the server
> (not the client).
>
> -sm
>
> On Tue, 14 Oct 1997 23:17:54 GMT, slices17_at_ix.netcom.com
> (Lots-A-Pizza) wrote:
>
> >Hello!
> >
> >I need some help here. I am trying to write a PL/SQL procedure that
> >opens a file on the Oracle server and reads from it. We are running
> >Oracle 7.3 on a Windows NT 4.0 server. I notice that there is a
> >package that came with the RDBMS called UTL_FILE, and in that package
 

> >there are a few file operation procedures. One of them is FOPEN. It
 

> >is supposed to open a file for me, but I've had very little luck with
 

> >it. I keep getting the UTL_FILE.INVALID_PATH exception raised.
> >
> >Lets say I am trying to open the file "ray.txt" in the "d:\raytemp"
> >directory. Can someone tell me how to properly specified the path
 and
> >the file name?
> >
> >Thanks in advance!
> >
> >Ray
Received on Wed Oct 22 1997 - 00:00:00 CDT