UTL_FILE problem

[Quoted] I'm trying to use UTL_FILE (for the first time ever), to write a file on [Quoted] an NT Server. Whenever I try to run it, I get a UTL_FILE.INVALID_PATH exception.

[Quoted] I've modified initorcl.ora to include UTL_FILE_DIR = * (for testing--initially I had it limited to one specific directory) and I've [Quoted] stopped and restarted ORCL. Actually, I've rebooted the server just to [Quoted] be sure. I'm running the script on on the server, too.

Here's my code:

DECLARE

   v_filename          VARCHAR2(12)    := 'TEST.MAIL';
   v_file_loc          VARCHAR2(40)    := 'C:\';
   v_file_mode         VARCHAR2(1)     := 'A';
   v_file_handle       UTL_FILE.FILE_TYPE;

BEGIN

   v_file_handle := UTL_FILE.FOPEN (v_file_loc,
                                    v_filename,
                                    v_file_mode);

(I've also tried directories other than the root.) Does anyone have any [Quoted] clues about what I might be doing wrong?

Thank, very much, in advance.

Bob

--
Bob M.

[Quoted] Step outside.  The graphics are AMAZING!


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.