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
Report Printing Issue
Return to Discussion Forum
Post New Message
Is there any expert to solve this?
what is difference between String and string(data type) in c#?
what is a resource file...
Horizontal Scroll Bar for a listview control
Anil Kumar ...
Last 7 Days
Awards & Gifts
Articles Rss Feeds
Forum Rss Feeds
Talk to Webmaster Tony John
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India