Re: UTL_FILE and mapped drives

Hi Brian,

This just come in to my mind:
Does the "oracle" user have access read/write on the network dirves usally oracle run as the system user if you don't specific set an other user to run oracle
under NT.

/Anders

Brian Membrey wrote:

> Hi
>
> I've set up an extensive package under Ora 8i on NT to generate a number of
> text files using UTL_FILE.. UTL_FILE behaves OK for all local destination
> directories included in a UTL_FILE_DIR specification in INIT.ORA.
>
> BUT it will not work with drives mapped to other nodes in the network.
> Tried both NT and AS/400 destinations, write premissions are fine and I can
> copy files outside of UTL_FILE, but any attempt to FOPEN raises an unhandled
> internal exception in UTL_FILE
>
> Tried UTL_FILE_DIR = * (which should make everything available - can then
> write to local drives, but still not to a mapped drive)
>
> Any ideas or is simply not possible for some reason????
>
> TIA
Received on Sat Aug 19 2000 - 01:33:02 CEST