Re: Reporting with dynamic sql

-----Stuff snipped for brevity-----

Sybrand Bakker wrote:
> What you need is a REF CURSOR.
>
> Like this
>
> variable cur REF CURSOR
> begin
> open :cur for
> '<your query *without temporary tables* here';
> end;
> /
> print cur
>
> And that is it.
>
> And yes, this is documented.
>
> --
> Sybrand Bakker, Senior Oracle DBA

Sybrand,

You example above put me on the right path. I finally found what I was looking for to format my report the way I want it.

Thanks !

Denis Received on Wed Aug 16 2006 - 13:28:01 CDT