Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: REF CURSOR and PLSQL Tables

Re: REF CURSOR and PLSQL Tables

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Sat, 21 Jul 2001 21:55:19 GMT
Message-ID: <3B2FD8A8.7DF1EB10@attws.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US