Re: Q: Stored procedures - result sets

A copy of this was sent to "huh" <huhhy_at_rocketmail.com> (if that email address didn't require changing) On Thu, 5 Aug 1999 09:38:16 +0200, you wrote:

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

absolutely, yes. it is called a ref cursor.

See the URL in my .sig below and then the link "Getting Result Sets from Stored Procedures (HOWTO)"

>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?

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Aug 05 1999 - 07:28:12 CDT