Re: problem of sys.utl_file.fopen

"Aray" <1_at_2.3> a écrit dans le message de news: dp0ekr$u2m$1_at_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
|
|

I don't see the Oracle version in your post.

And is 'C:\temp' in utl_file_dir parameter?

Regards
Michel Cadot Received on Thu Dec 29 2005 - 05:01:20 CST