Re: Ref Cursors and Pl/SQL tables

From: Mani Visweswaran <maniv_at_mindspring.com>
Date: Sun, 8 Apr 2001 10:53:22 -0400
Message-ID: <9apu13$8u$1@slb1.atl.mindspring.net>

I think I understand the question, but I don't know the answer. In fact, I wanted to do the same thing recently.

Basically, I wanted to read some stuff from various tables, build a PL/SQL table in the stored procedure, and return a REF CURSOR to that "table" back to the calling program. The result set I wanted to return back could not be created in a single SQL statement.

Mani Visweswaran

"Mike Moore" <hicamel_at_mail.home.com> wrote in message news:g7vz6.8479$4L4.916784_at_news1.frmt1.sfba.home.com...
> First of all, a table is not read "into" a cursor. It's not like the table
> is
> duplicated somewhere.
> What do you mean by a temporary table? It would help if you show an
> example of what you are not looking for.
> Mike
>
> Jon Glickman <jglickma_at_lynx.neu.edu> wrote in message
> news:3ACD1D5F.BF3CCA7F_at_lynx.neu.edu...
> > Does anybody know how to read a PL/SQL table into
> > a ref cursor without using a tempory table in between.
Received on Sun Apr 08 2001 - 09:53:22 CDT