RE: Stored procedures that return multiple rows

[Jack C. Applewhite]

Paul,   For a couple of projects that I've worked on, several Java programmers have liked having Ref Cursors returned from PL/SQL stored procedures.  They could work with those much more easily than PL/SQL tables.   Can't remember if we even tried VArrays. I don't think I'd like them for returning table data - too much work to populate them.   Jack -------------------------------- Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Baumgartel Sent: Thursday, August 23, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject: Stored procedures that return multiple rows We're considering a mandate that all database access be via stored procedures (probably in packages).  These would be called either via OCCI (the C++ call interface) or JDBC.  My question is whether anyone's had experience in returning a result set from a PL/SQL procedure under these circumstances, and how it was implemented:  did you return a ref cursor, an index-by table, a set of arrays....?  Any advice will be appreciated.  Thanks!   Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED]