Re: Procedure "fopen" in the utl_file package

(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 Fri Oct 17 1997 - 00:00:00 CDT