How to pass ref Cursor to Oracle Stored Procedure
07 Oct 2010
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"
Please provide me some good solution to resolve my problem.
Date: 07/Oct/2010 Rating:
You can have a look at the concept of assocaite Array and ODP.Net.
This thread is locked for new responses. Please post your comments and questions as a
If required, refer to the URL of this page in your
Start new thread
Last 7 Days
Anil Kumar ...
Awards & Gifts
Articles Rss Feeds
Forum Rss Feeds
Talk to Webmaster Tony John
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India