Re: REF Cursor

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 5 Jun 2006 10:32:41 -0700
Message-ID: <1149528761.201123.73090@j55g2000cwa.googlegroups.com>

deepa.jayakumar_at_gmail.com wrote:
> Say, I have 20 REF cursors in a StoredProcedure that needs to be
> returned to the client.
> Is it possible to put all the REF Cursors in a array and return it as a
> single variable from a stored procedure instead of sending it in 20 out
> parameters?

PLS-00990: Index Tables of Cursor Variables are disallowed

suggests that this is not possible.

Hth,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Mon Jun 05 2006 - 12:32:41 CDT