| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> how to use multiple ref cursors
Currently we have some stored procedures that hand a ref cursor back to a
call from the Microsoft OLEDB for Oracle driver. The Microsoft driver
interprets the ref cursor as an ADO recordset and processes it accordingly.
There are a number of functions in the application that require the user to
call these procs in sequence. In order to improve performance, we would like
to retrieve the data faster, possibly in one call or multiple calls
simultaneously. One idea is to try to return multiple ref cursors (ie.
multiple recordsets) back from the proc. Can anyone offer any insight into
how we can do this? Any help you can provide would be greatly appreciated.
John Fedock
"K" Line America, Inc.
john.fedock_at_kline.com
www.kline.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fedock, John (KAM.RHQ)
INET: John.Fedock_at_KLINE.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 17 2002 - 16:48:28 CDT
 |
 |