Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE-Package
Thanks for the correction Mark - must have miss read the documentation
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.
Mark Gumbs <mgumbs_at_nospam.hotmail.com> wrote in message
news:3764c0d1.0_at_145.227.194.253...
> It doesn't invalidate unix security. It just means that utl_file can
write
> to anywhere as long as its in the unix permission bounds. The tool cannot
> override an operating system.
>
> Mark
>
> Kevin A Lewis wrote in message ...
> >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 - 05:34:33 CDT