Forums » .NET » .NET »

How to pass ref Cursor to Oracle Stored Procedure

Posted Date: 07 Oct 2010      Posted By:: Devesh Kumar Profile photo    Member Level: Gold  Member Rank: 0     Points: 1   Responses: 1


I need to send multiple data of table having parent child relationship at a time in the oracle stored procedure.
I am trying to use a ref cursor as a input parameter in the Oracle Stored Procedure.I can eaisly pass the ref cursor as an input parameter in the SQL Stored Procedure but while passing it in Oracle i am getting something "Unable to bind Data..." like error.

I read a document provided by the Microsoft that it does not support this functionality. See below link under section "Ref_Cursors as output parameters only";en-us;322158

Please provide me some good solution to resolve my problem.

Devesh Kumar


#559358    Author: giridharan arul      Member Level: Bronze      Member Rank: 0     Date: 07/Oct/2010   Rating: 2 out of 52 out of 5     Points: 0

You can have a look at the concept of assocaite Array and ODP.Net.

Post Reply     

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

  • Return to Discussion Forum
  • Start new thread

  • Subscribe to Subscribers
    Active Members
    TodayLast 7 Daysmore...

    Awards & Gifts
    Talk to Webmaster Tony John

    Online Members

    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India