Re: Getting result sets from stored procedures

From: Alan Moor <asmoor_at_ix.netcom.com>
Date: Mon, 16 Aug 1999 05:55:59 -0400
Message-ID: <7p8o1s$d84@dfw-ixnews15.ix.netcom.com>

On a VB project, I attempted, at length to get a ref cursor to work as a stored procedure returning a result set with no luck. Have not investigated Oracle 8. The only place I have seen a ref cursor work is Oracle products (Forms 5), where you can set the data source for a block to a stored procedure.

The solution in my case was to base my result set on a fairly complex view.

Good Luck

Bob Kline wrote in message <7p4ijb$lat_at_nnrp1.farm.idt.net>...
>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
>
>
>
Received on Mon Aug 16 1999 - 04:55:59 CDT