Q: Stored procedures - result sets

From: huh <huhhy_at_rocketmail.com>
Date: Thu, 5 Aug 1999 09:38:16 +0200
Message-ID: <7obf2t$ars$2@ns.felk.cvut.cz>

Hi,

I'd like to know whether ORACLE supports procedures (functions) which returns result sets.

I didn't find anything in manuals. However help files for ODBC drivers tell us something about it.
Driver from MS adds new ODBC escape keyword to invoke such SP but it seems to be a 'fake' - set is returned through the output param. Driver from Intersolv supports similar 'fake mechanism' but unfortunatelly I didn't find any example how to invoke such SPs. If someone can show an example of odbc {call ...} example....

I have additional questions:
1) If ORACLE doesn't support SP with resultsets is similar 'fake mechanism'

possible using OCI?
2) If this feature is supported, when can I find more information? 3) Where can I find an explanation how does it work for MS driver

and as well for Intersolv driver?

--
Thank you for keeping >anti-spam< habit: not including my address in your reply. Received on Thu Aug 05 1999 - 02:38:16 CDT