Passing a recordset/cursor type parameter to the Oracle Stored Procedure
Hi,
I need to Pass a recordset/cursor type parameter to a Oracle Stored Procedure
as one of its parameters.
I am unable to bind the recordset to a parameter.
Thanks in advance..
Re: Passing a recordset/cursor type parameter to the Oracle Stored Procedure
The ADO Recordset object is a proprietary binary object that Oracle does not
understand how to parse. While its individual fields might be passed as elementary
data types I don't expect Oracle (or SQL Server for that matter) knows how
to accept a Recordset. In the future, I expect SQL Server to accept Table
objects and perhaps XML as arguments, but not binary Recordsets.
bv
<bond0073@hotmail.com> wrote:
>
>Hi,
>I need to Pass a recordset/cursor type parameter to a Oracle Stored Procedure
>as one of its parameters.
>
>I am unable to bind the recordset to a parameter.
>
>Thanks in advance..
>