problem of sys.utl_file.fopen

From: Aray <1_at_2.3>
Date: Thu, 29 Dec 2005 18:28:00 +0800
Message-ID: <dp0ekr$u2m$1@news.cn99.com>

While I run following scripts

---

Declare

   myFile         sys.utl_file.File_type;
   path           Varchar2(50);
   fileName       Varchar2(50);
Begin
  path            := 'C:\temp';
  fileName        := 'temp';

  myFile := sys.utl_file.fopen(path,fileName,'r'); --Error countered here end ;

---

get following Error:

---

ORA-29280: Invalid directory path
ORA-29280: In "SYS.UTL_FILE",line 18
ORA-29280: In "SYS.UTL_FILE",line 424
ORA-29280: In line 8


---------------------------------------------------------

It seems c:\temp\temp donesn't exist, But I am quite sure the c:\temp\temp is available on the oracle server

---

C:\Documents and Settings\Aray>type c:\temp\temp temp

---

Any hints?

Thanks Received on Thu Dec 29 2005 - 04:28:00 CST