I am trying to read a file from inside sqlplus.
The server that tha data-base is on is \\xx1-oracledev
and the server that has the files i want to read is on \\xx1-util01\
From windows I can get to the directroy and open the file. but I get a ORA-29283 error when my code tries ot execute the util_file.fopen command.
I need some help
the oracle 10g database in on a Windows 2003 server
-- create the directory
CREATE DIRECTORY TEST01 AS '\\xx1-util01\IT-DEV$\Deployment\Dev\ProductMasterUpload\';
-- check its there
select * from all_directories;
SYS | TEST01 | \\xx1-util01\IT-DEV$\Deployment\Dev\ProductMasterUpload\
-- try to read a file from that directory
f := utl_file.fopen('TEST01','TEST.TXT','R');
WHEN NO_DATA_FOUND THEN EXIT ;
WHEN OTHERS THEN