Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE getting invalid path on Oracle 7.3.4.
"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