Re: ULT_FILE_DIR with n directories??

Gonzalo wrote:
>
> Hi,
> I'm using Oracle 8.0.5 - Solaris 2.7.
> The package utl_file, works fine, but I want to have more
> than one directory. I tried to set the UTL_FIL_DIR parameter
> with more than one, and it didn't work.
> Eg: "UTL_FILE_DIR=/u02,/tmp" only works /u02.
>
> If I have a subdirectory under /u02 (Eg:/u02/tmp) it also didn't
> work.
>
> Is this correct? Can I have more than one directory to use
> with the utl_file package?
>
> TIA,
> Gonzalo.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Have multiple parameters...

utl_file_dir = xxx
utl_file_dir = yyy

etc

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse