Procedure "fopen" in the utl_file package

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 Tue Oct 14 1997 - 00:00:00 CDT