Re: Oracle stored procedure limits with resultsets

A copy of this was sent to "Christian BRUNO" <brunoc_at_ifrance.com> (if that email address didn't require changing) On Mon, 20 Mar 2000 11:09:39 +0100, you 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
>

cursor variables were added to the database in release 7.2

I believe you are referring to the fact that the ODBC adapters do not support ref cursors until the 8.0.5 release of the ODBC adapter (you need the 8.0.5 release of the odbc client is what that is saying).

>
>
>
>
>
>

-- 
http://osi.oracle.com/~tkyte/
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation