Re: UTL_FILE-Package

You may like to look at the documentation around the Oracle Parameter

UTL_FILE_DIR but avoid * as this invalidates all UNIX security

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Paul Q <paulq_at_home.com> wrote in message news:DAN83.7701$Yr2.124726_at_news2.rdc1.on.home.com...
> Make sure file read permissions are available to all
> chmod 444 file
>
> mme wrote in message <7k06vu$t8n$2_at_news00.btx.dtag.de>...
> >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 Mon Jun 14 1999 - 03:41:20 CDT