Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: DA Morgan <damorgan@exxesolutions.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Array of cursors: is it possible?
Date: Fri, 04 Apr 2003 08:48:56 -0800
Organization: EXE
Message-ID: <3E8DB778.209DEDE1@exxesolutions.com>
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
References: <11f54ca0.0304040517.3bc74ca4@posting.google.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yasure!unknown@splish28.drizzle.com
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)
X-Complaints-To: abuse@supernews.com
Lines: 18
Xref: newsfeed1.easynews.com comp.databases.oracle.server:182015
X-Received-Date: Fri, 04 Apr 2003 09:49:34 MST (news.easynews.com)

hayt wrote:

> Hi to all!
> As subject says, I would to know if in Oracle(8i) is possible to
> declare and use arrays of cursors.
> My target is to return an array of cursor from a stored procedure and
> take it in a piece of java code for processing.
> How can I do it (in PL/SQL and in the java code)?
> Thanks so much.

Do you mean a REF CURSOR with an array data type or do you mean return an
array from a procedure?

I'd suggest going to http://asktom.oracle.com and you should find some
good resources there.

Daniel Morgan