DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Passing a recordset/cursor type parameter to the Oracle Stored Procedure

Hybrid View

  1. #1
    Guest

    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..


  2. #2
    Bill Vaughn Guest

    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..
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center