You must Sign In to post a response.

How to pass ref Cursor to Oracle Stored Procedure

Hi,

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"
http://support.microsoft.com/default.aspx?scid=kb;en-us;322158

Please provide me some good solution to resolve my problem.

Thanks,
Devesh Kumar


Comments

Author: giridharan arul07 Oct 2010 Member Level: Bronze   Points : 0

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

http://www.oracle.com/technetwork/issue-archive/2007/07-jan/o17odp-093600.html


Sign In to post your comments