Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE-Package

Re: UTL_FILE-Package

From: Kevin A Lewis <KevinALewis_at_Hotmail.com>
Date: Mon, 14 Jun 1999 11:34:33 +0100
Message-ID: <vP493.1715$Tf6.11041@newreader.ukcore.bt.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US