On 4/13/07, Steve P Shiflett <Steve(dot)P(dot)Shiflett(at)macys(dot)com> wrote:
>
> I wish to display the output of a cursor but haven't discovered the trick.
> Here's what I'm doing:
>
>
According to the documentation, you can fetch from a returned
refcursor like this:
FETCH ALL IN "<unnamed cursor 1>";
You can name the refcusor inside your function like this:
my_cursor refcursor default 'something';
which makes it easier to get from sql script from a known name.
merlin