Re: utl_file paths

From: Sean Dillon <sean_at_digisys.net>
Date: Tue, 17 Aug 1999 13:22:26 -0600
Message-ID: <7pcd37$2rs$1@ruby.digisys.net>

Thanks, Mario.

I'd prefer not to use the utl_file_dir = * because of security concerns. I _should_ be able to list the specific directories to enable file i/o, and I've gotten it to work fine with directories on the local machine -- just not shares or mapped drives.

So...

Anybody done this with specific shares or mapped drives?

Thanks.

Sean

Mario Bucsics wrote in message <37B9A335.C74A27EB_at_siemens.at>...
>Yes you just have to make these entries in the initORACLE_SID.ora file:
>
>utl_file_dir = *
>
>After you restart the instance you should be able writing to any Directory
on
>the disk
>
>Regards
>
> Mario Bucsics, SIEMENS AG
>
>Sean Dillon wrote:
>
>> (NT Environment)
>> I'd like to use the utl_file package in a trigger to export inserted or
>> updated data to a text file. I'm having trouble identifying the path -
>> local paths work fine because they can be referred to simply, like
'/mydir',
>> but I can't seem to figure out how to specify a share. Have tried UNCs
and
>> permanent drive-letter mappings.
>>
>> Anybody successfully used utl_file to write to a dir on a machine other
than
>> the Oracle server itself?
>
Received on Tue Aug 17 1999 - 14:22:26 CDT