Oracle and multiple recordsets


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Oracle and multiple recordsets

Hybrid View

  1. #1
    JeanH Guest

    Oracle and multiple recordsets


    Hello

    We are using MDAC 2.6 to connect to Oracle 8i from VB6 SP5. When we try
    to execute a stored proc that returns multiple recordsets we get the error:
    "Current provider does not support returning multiple recordsets from a single
    execution."

    Are we doing something wrong? Is it possible to work around the problem without
    "dividing" the stored proc into multiple ones?

    Thanks


  2. #2
    Jay Guest

    Re: Oracle and multiple recordsets


    You can't retrieve multiple recordsets from an Oracle stored procedure, only
    SQL Server. Check out the following Microsoft support article for more info,
    Q176086.

    "JeanH" <jeanh@allmarketing.com> wrote:
    >
    >Hello
    >
    >We are using MDAC 2.6 to connect to Oracle 8i from VB6 SP5. When we try
    >to execute a stored proc that returns multiple recordsets we get the error:
    >"Current provider does not support returning multiple recordsets from a

    single
    >execution."
    >
    >Are we doing something wrong? Is it possible to work around the problem

    without
    >"dividing" the stored proc into multiple ones?
    >
    >Thanks
    >



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