Re: Stored Procedures and CURSORs

Stored procedures cannot direcltly work with result sets. Internally you can use the record sets but that is confined to the context of the PL/SQL block. The typical approach (very crude) is to dump the results into a temporary table then have your interface query that table for its result set.

Todd Verstraten
mailto:tverstrat_at_tier3.com
http://www.tier3.com

Rick Meshriy <meshriy_at_xsis.xerox.com> wrote in article <587f39$kgr_at_news.cp10.es.xerox.com>...
>
> Hi,
>
> Would someone please tell me if it is possible to pass CURSORs into
 and/or out
> of Stored Procedures? If it is, please show me some sample code how.
>
> My end application is written in Visual FoxPro. Using SQL Pass-Through,
 I can
> successfully connect to it, run SQL commands and even execute some Stored
 

> Procedures. The problem is that I would like a results set back from the
 

> Stored Procedure and I do not know how to do that.
>
> Any and all help will be greatly appriciated.
>
> Thanks,
> Rick Meshriy
>
Received on Mon Dec 09 1996 - 00:00:00 CET