Re: Getting result sets from stored procedures

From: <morris_minor_at_my-deja.com>
Date: Mon, 16 Aug 1999 11:30:54 GMT
Message-ID: <7p8spe$tng$1@nnrp1.deja.com>

MSDN knowledgebase article Q176086.

In article <7p4ijb$lat_at_nnrp1.farm.idt.net>, "Bob Kline" <bobklin_at_idt.net> 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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 16 1999 - 06:30:54 CDT