Re: UTL_FILE_DIR = * question

Walter, you are precisely correct. The error was at the line of "fopen".

I reset the permission bits to 777(rwx for all) and I still get the same "Invalid Path ...". Now I believe it is the Oracle8i/Linux, not the PL/SQL code, nor the OS.

Anyone has successful exp. with Ora8i/Linux ???

Jack

In article <3A3E1A42.6CD0C856_at_Unforgetable.com>,   Walter T Rejuney <BlueSax_at_Unforgetable.com> wrote:
> cwang9_at_yahoo.com wrote:
>
> > All:
> >
> > I got "Invalid Path ..." error when I tried to READ a
> > Unix text file. I am running Oracle8i on my home PC.
> >
> > Then I updated the init.ora file and added this line:
> >
> > UTL_FILE_DIR = *
> >
> > This should add all directories to its access list. However
> > I got the exact same "Invalid Path ..." error,,,
>
> Are you sure that Oracle has read permissions fir the target file. It
> doesn't matter in the slightest bit whether the account you are logged
> into UNIX with has read permissions on the file - it only matters that
> Oracle has write permissions because it is the Oracle account that is
> reading the file, not your login session. Typically this would probably
> mean that you need 444 permissions on the file itself since the "world"
> privilege is the most important one in this case.
>
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Dec 19 2000 - 22:14:45 CST