unable to read file using UTL_FILE
Dear all,
I need to read files located on a remote machine (perhaps using a mapped network drive) using UTL_FILE. I am trying to do the following …..
Utl_file.fopen(netpath, filename, 'r'); ---- where "netpath" is a directory object pointing to a mapped network drive z:.
The above statement works perfectly fine in the case of a local drives situated on the database server itself. However when I use a network mapped drive I get the following error
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
Could anyone please help regarding how to open an read a file from a network mapped drive or a file that is located on another machine. I am using Oracle 10 R1 on Windows 2003
Thanks in advance
L