Re: Using UTL_FILE

Sybrand Bakker wrote:
>
> "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
> > >
> >
> >
>
> As far as I know using * doesn't work. You need to specify individual
> directories.
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA

'*' does work - but of course its a disaster waiting to happen...

for i in ( select file_name from dba_data_files ) loop   <open file i>
end loop;

hmmmmmmmmmmmmmmmmm

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."