Re: UTL_FILE getting invalid path on Oracle 7.3.4.

From: J Alex <jalexanderssd_at_yahoo.com>
Date: Wed, 18 Sep 2002 18:20:37 GMT
Message-ID: <Vt3i9.290378$Rx4.3789789@twister.tampabay.rr.com>

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> On 18 Sep 2002 04:22:41 -0700, billwilliams_at_qcsoftware.com (Bill
> Williams) wrote:
>
> >I am working on a client's legacy system running Oracle 7.3.4(PL/SQL
> >2.3.4) running on AIX 4.2. I am trying to use the utl_file package.
> >I have set utl_file_dir=* in the init ora file. The directory I am
> >writing to has its permissions set to 777. The path I am trying to
> >write to is /NAUTILUS/HOSTCOMM/UPLOAD. As you can see, there is no
> >trailing / character. No matter what I do, I get the invalid path
> >error.
> >
> >Any ideas?
>
> Setting utl_file_dir to * will compromise security and stability of
> the server and AFAIK it has never worked: you need to set explicit
> directories seperated by semicolons

Haven't used it lately, but way back when on HPUX 10 with Oracle 7.3.4 we used '*' on a test box and it worked fine. But it definitely created a potential security problem. Received on Wed Sep 18 2002 - 13:20:37 CDT