Re: UTL_FILE

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 15 Feb 2005 07:20:24 -0800
Message-ID: <1108480824.375901.134360@g14g2000cwa.googlegroups.com>

Zephyr wrote:
> Thanx,
>
> this solves my problem, but I can't write in UNC notation pathes
> even if the oracle user has write access to the UNC share.
>
> I always get
>
> ORA-29283: invalid file operation
>
> Is it possible to write in UNC pathes?
>
> Thanx
> Patrick
> > 4 fHandle_ := utl_file.fopen('FOO', 'foo_test.txt', 'w');

I don't think Oracle will accept UNC \\ names or mapped drives (not confirmed). You may have to use local fixed drive. If you use Java's File IO, then it can write to UNC or mapped drives.

Regards
/Rauf Received on Tue Feb 15 2005 - 09:20:24 CST