Re: [Q] How to return a result set from a stored procedure through ODBC?

On Thu, 26 Jun 1997 22:20:29 GMT, iarld_at_connectnet.com (Lee Doty) wrote:

>Our company is porting a large product (wharehouse automation system)
>from MS-SQL Server to Oracle.
>
>Here's the problem: In order to perform many operations within their
>contractual time limits, we used quite a few stored procedures. Many
>of these procedures return a result set (or 2), and we simply use
>SQLFetch and SQLMoreResults to get at these results.
>
>

It is possible to return result sets from Oracle V7.3 and above using cursor variables. See the documentation to learn more about this new PL/SQL feature. (I have successfully done it using Delphi 3 as a front end).

Regards,

Dave Macpherson Received on Sat Jun 28 1997 - 00:00:00 CDT