Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Getting result sets from stored procedures
A copy of this was sent to "Bob Kline" <bobklin_at_idt.net>
(if that email address didn't require changing)
On Sat, 14 Aug 1999 16:12:43 -0400, you wrote:
>In the Sybase world there is very elegant support for returning a result set
>from a stored procedure. Any select statement in the procedure is available
>to the client as a result set, which is very easy to grab from ODBC or
>Perl's DBI. The closest I've been able to find in the Oracle world is the
>REF CURSOR, but it appears that the REF CURSOR needs to be set up as one of
>the parameters for the stored procedure. I haven't been able to find any
>way to call such a stored procedure from ODBC or DBI and get to the result
>set. Anyone have any tips on where to look?
>
>Thanks,
>Bob Kline
>bkline_at_rksystems.com
>
>
I have some examples at the URL in my signature below.
--
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 Mon Aug 16 1999 - 06:49:28 CDT