Re: Oracle stored procedure limits with resultsets

Download Oracle's OLE DB Provider from http://technet.oracle.com/

It is designed to work with ADO and it supports PL/SQL REF Cursor (resultsets).

Sunil

On Mon, 20 Mar 2000 11:09:39 +0100, "Christian BRUNO" <brunoc_at_ifrance.com> wrote:

>Hello,
>
>please could you confirm this limit of Oracle Server, and tell me where to
>find an official document or any Oracle Documentation about this ?
>
>"Support for stored procedures (functions) that return a cursor or resultset
>was not available until Oracle Server Version 8.0.5 or higher"
>
>how to do if i have to write a stored procedure that selects more that 1 row
>from a table and returns the result to a Win32 Client ? is there a solution
>compatible with ODBC ? or ADO ? other ?
>
>any help would be greatly appreciated
>
>Regards,
>Christian
>
>
>
>
>
>
>
>
Received on Mon Mar 20 2000 - 00:00:00 CST