Some recollection - I may be wrong - of passing REF CURSORs about as parameters. If you can pass back multiple REF CURSOR parameters, would that help?
9i provides table functions. Results can be passed back from row sources without waiting for completion. Table functions can be parallelised too. Cheers, John Thomas Oracle development DBA (available for contract performance analysis and just about anything else.) ticle <[EMAIL PROTECTED]>, Fedock, John (KAM.RHQ) <[EMAIL PROTECTED]> writes >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 -- John Thomas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Thomas 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).
