Re: Acessing password protected network drive

Am 14.02.2014 20:32, schrieb Tiago:
> Oracle 11.2.0.2 running on Windows 2008 server 64 bit.
>
> I need to access a remote network path using UTL_FILE and a DIRECTORY component, to collect and process some XML files.
>
> The problem is the server where the files I want (over the network) does not belong to me, but the fine folks who run this server granted me access to a shared folder, something along the lines of //theirserver/mydata.
>
> Trouble is, they demand password authentication. If I connect through windows explorer, it will prompt for username and password and after entering the authentication data I have access granted, no problems. Unfortunately, UTL_FILE.FOPEN does not provide a way to enter username and password and then Oracle can't connect and can't read files. Does anyone know a workaround? Is there any way, even if a Java way?

CIFS mount it somewhere in the local file system of your DB server, then CREATE DIRECTORY there.

Regards
Peter

-- 
Climb the mountain not to plant your flag, but to embrace the challenge,
enjoy the air and behold the view. Climb it so you can see the world,
not so the world can see you.                    -- David McCullough Jr.