Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE getting invalid path on Oracle 7.3.4.

Re: UTL_FILE getting invalid path on Oracle 7.3.4.

From: J Alex <jalexanderssd_at_yahoo.com>
Date: Wed, 18 Sep 2002 11:52:36 GMT
Message-ID: <8OZh9.99991$R7.1456672@twister.tampabay.rr.com>

"Bill Williams" <billwilliams_at_qcsoftware.com> wrote in message
> 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?
>

Did you check the parameter in the database to make sure that the system parameter is utl_file_dir=* (i.e. that the right init.ora was changed and the database bounced). Received on Wed Sep 18 2002 - 06:52:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US