| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> 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
 |
 |