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. [EMAIL PROTECTED] www.kline.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fedock, John (KAM.RHQ) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
