Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> FOPEN returning errors
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
![]() |
![]() |