Re: UTL_FILE-Package

Hi,

Ok, I've been playing around with UTL_FILE myself for a few days, and here's a few things which might be of help to you ...

(1) The only difference I know between a plain ASCII file and a file created by the UTL_FILE package is the owner. Oracle owns files created by UTL_FILE (You might have noticed that you can't modify the file in Unix unless you belong to the Oracle owner group).

(2) I've done a quick test to see if I can read plain ASCII files NOT created by Oracle, and it seems to be openig the file without any problems. I've appended some text to foreign files as well, again without any problems.

(3) Permissions. You mentioned you've checked these. Is the path given to the open_file function correct? Check the permissions of the directory which contains the file, does it have read and write access for you?

Well, there's my £0.02 worth. Hope it helps.

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 Tue Jun 15 1999 - 07:10:34 CDT