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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Using UTL_FILE

Re: Using UTL_FILE

From: MarkyG <markg_at_mymail.tm>
Date: 22 Aug 2001 00:59:59 -0700
Message-ID: <ab87195e.0108212359.2dd8178d@posting.google.com>


Even if you say * to the parameter, utl_file will not override operating system permissions. so if you cannot write in directory c:\temp\test on your OS, utl_file will not put anything there.

Mark

"Scott Mattes" <ScottMattes_at_yahoo.com> wrote in message news:<RLcg7.33$ZT.55264_at_news1.news.adelphia.net>...
> But, if that was done, wouldn't the user have access to ANY file in ANY
> directory (including system files)?
>
> "Christof Kaiser" <Kaiser_at_logiball.deREMOVETHIS> wrote in message
> news:3B77A421.71DF40E7_at_logiball.deREMOVETHIS...
> >
> >
> > carlog wrote:
> >
> > > hi all,
> > > only a little question, is possibile write an output file from PL/SQL
> and
> > > save data into a local directory, but i don't want use the path stored
> in
> > > 'utl_file_dir' parameter.
> >
> > dont know if it helps, but you could set 'utl_file_dir' to '*' and be free
> > where to put your output files.
> >
> > christof
> >
Received on Wed Aug 22 2001 - 02:59:59 CDT

Original text of this message

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