Re: UTL_FILE getting invalid path on Oracle 7.3.4.

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 18 Sep 2002 23:57:44 -0700
Message-ID: <92eeeff0.0209182257.14b47485@posting.google.com>

"J Alex" <jalexanderssd_at_yahoo.com> wrote in message news:<Vt3i9.290378$Rx4.3789789_at_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?
> >

Case matters on UNIX so check that. Also try changing the ownership of the directory to oracle:dba. Using "*" should be avoided unless you want to open the entire server to Oracle users.

/Rauf Sarwar Received on Thu Sep 19 2002 - 01:57:44 CDT