Re: Reporting with dynamic sql

On 16 Aug 2006 05:17:01 -0700, "Deltones" <vibroverb_at_hotmail.com> wrote:

>On the other hand, let's say I use your construct instead of a temp
>table. I'm still not out of the wood am I?
You should be. But then you pretty much didn't disclose anything

 I'll not be able to use
>SQL*Plus reporting handling and have to construct every line of the
>report by hand and dbms_output.put_line everything right?

You would be the first who would feel compelled to use dbms_output.put_line everywhere.

And yes, you can spool to a html file, so you also don't need to use http.print calls everywhere.

--
Sybrand Bakker, Senior Oracle DBA