Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Webserver Output
In article <621n0e$27n$1_at_opera.iinet.net.au>, "Vaughan Castine" <vaughan_at_unforgettable.com> wrote:
> Use the UTL_FILE package.
>
> Ken Nichols wrote in message <3441DDC3.6FFC_at_mcsilo.ilo.dec.com>...
> >Dan,
> >
> >I haven't tried it, but there's no reason that DBMS_OUTPUT shouldn't
> >work. If turning on SERVEROUTPUT is the problem, that can be done
> >automatically (via login.sql) for the user session connected to the
> >PL/SQL agent.
> >
> >If this doesn't work, email me and I'll try it here.
> >
> >Ken
> >
> >Dan Nichols wrote:
> >>
> >> Hi Everyone:
> >>
> >> Using the Webserver PL/SQL agent, it it possible to send the output of a
> >> query to a file?
> >>
With some slight modifications of the OWA_UTIL package you can use it to produce files in Excel-format and (depending on browser I assume) even have them launch Excel automaticly - the users love it!
If you want to know details send mail.
Göran
-- goran_at_champion.se Göran Korsgren, ChampionChip AB, Stockholm, Sweden If replying by mail, please remove x. from address!Received on Thu Oct 23 1997 - 00:00:00 CDT