Re: REF CURSOR and PLSQL Tables

Niloufar wrote:

> Hello,
>
> I have a procedure that returns three PLSQL tables that are each one
> dimensional.
> I've been asked to write a wrapper around this procedure and instead return
> the
> result in a reference cursor variable. After reading on the ref cursors,
> I've noticed
> that I have to use a "select-statement" in order to OPEN the ref cursor.
> However,
> I have no idea of how to do that with PLSQL tables returned from my
> procedure.
> I don't want to store this information in a table in the database and then
> read it back
> using select. Are there any other ways?
>
> Any help will be appreciated.
>
> Thanks in advance,
> Niloufar

Drop the PL/SQL tables and just create the same data set in the REF CURSORS.

Daniel A. Morgan Received on Sat Jul 21 2001 - 16:55:19 CDT