Re: Returning resultsets with Oracle Stored procedures

From: Keith Boulton <boulke_at_globalnet.co.uk>
Date: 1997/11/29
Message-ID: <347f7c63.51184209@read.news.global.net.uk>#1/1

On Fri, 28 Nov 1997 02:01:28 -0500, bruce_at_peergroup.com wrote:

>I'm looking for a way to to return recordsets using stored procedures
>and ODBC with an Oracle 7.x server. I haven't been able to find any
>examples of this anywhere.
>
> Any help would be appreciated.
>
> Thanks
>
>-----------------------------------------------------------------------
> Bruce Scanlan | bruce_at_peergroup.com
> Systems Integrator | 519 749 9554
> The PEER Group Inc |

I do not believe you can. The nearest you get to being able to return a result set from a stored procedure is to return a cursor reference variable and the client has to understand how to process this. I do not think the Oracle ODBC driver supports this. Oracle Objects for OLE does. Received on Sat Nov 29 1997 - 00:00:00 CST