Re: Using UTL_FILE

"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 Received on Mon Aug 20 2001 - 14:46:20 CDT