Re: UTL_FILE-Package

My experience has been this:

1. If you allow oracle to create the file using utl_file, it will be owned by Oracle and will have whatever permissions were inherited by the RDBMS when the unix oracle account started the instance.
2. If you create the file as an empty file in shell first and then have utl_file append to that file, the file ownership will not change. If I am running a pl/sql script from sqlplus, I will write a shell wrapper in which I will create the file and give it whatever permissions and ownership I desire and then pass that name as a directory and file name to the pl/sql routine. I've never had any problems with this.

Ken

mme wrote:
>
> Hi all of you!
>
> I´m experiencing problems using the UTL_FILE package.
> Creating textfiles isn´t a problem, but reading textfiles. ORA
> always reports "error opening file". I´ve checked the
> rights and stuff (Unix) and it´s always ASCII files.
>
> The only file that works is the ones ORA created.
> "Foreign" files get always rejected. I´ve tried with
> CR and CR/LF at the end of every line.
>
> Does ORA always have to be owner of the files, or
> is it enough to have rights on them?
>
> Is there a difference between a file created using UTL_FILE
> or a foreign plain ASCII file?
>
> Please help me?
>
> Regards,
>
> Mattias
Received on Sat Jun 19 1999 - 09:17:00 CDT