FOPEN returning errors

From: tk <theronk_at_charter.net>
Date: Mon, 11 Aug 2003 07:48:24 -0600
Message-ID: <vjf3qn32f632d1@corp.supernews.com>

Hi Folks:

More frustrating than I initially thought... I'm trying to run some of the Oracle file io samples...

I am getting the following error from a test package: SQL> BEGIN
  2 Debug.TestIt;
  3 END;
  4 /
BEGIN
*
ERROR at line 1:

ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 18
ORA-06512: at "SYS.UTL_FILE", line 424
ORA-06512: at "TKOUSEK.DEBUG", line 7
ORA-06512: at line 2


=================================================================

The errors happening on the FOPEN call...

SO here's my init.ora file entry (I am using Windows 2000) UTL_FILE_DIR=c:\tmp

and the package body for TestIt
  PROCEDURE TestIt
  IS
  BEGIN
     v_DebugHandle := UTL_FILE.FOPEN('\tmp', 'testFile.txt', 'w');   END TestIt;

For the first parm, I alread tried: '/tmp', 'c:\tmp'. 'c:/tmp'....

I also made sure the Windows 2000 permissions on c:\tmp were "Open" which they are...

DO I also have to perform some type of "Grant"???

thanks... Theron Received on Mon Aug 11 2003 - 08:48:24 CDT