Re: Ref Cursor problem

From: Vinayak Kulkarni <kdotvinayak.void_at_usadot.net>
Date: Wed, 13 Jun 2001 16:47:44 -0400
Message-ID: <9g8jhh$ec0$1@new-proxy.bscc.bls.com>

How about dumping the intermediate data into a global temporary table and then open a cursor on that table. I am assuming you are working with 8i

HTH,
Vinayak

"Jeff Miller" <jeffinsd_at_yahoo.com> wrote in message news:OyCV6.304$35.196172_at_typhoon.san.rr.com...
> I am summarizing a cursor using PL/SQL. Now I am trying to figure out
some
> way to get the summary information into a Ref Cursor to be passed out of
the
> stored procedure. Since a REF CURSOR can't use FOR UPDATE, I am trying to
> figure out how to put the summarized data in some form where I can use a
> SELECT statement in the REF CURSOR to retrieve the data. Any idea's?
>
> Thanks,
>
> Jeff
>
>
Received on Wed Jun 13 2001 - 15:47:44 CDT