oracle 'in refcursor' and 'datatable'

Topics: Data Access Application Block
Oct 18, 2008 at 6:50 AM
Edited Oct 18, 2008 at 6:51 AM
Hi

I am using EntLib 3.1 with .net 2.0, i want to send the datatable as 'in refcursor' to the stored procedure and based on a column 'status' it will execute either 'insert','update' or 'delete' commands in the Stored procedure

I am using ODP and changes the DAAB with the help of an tutorial for out ref cursor, now i want to enhance DAAB for passing in-refcursor and datatable

Kindly help me.

Thanks
Mahir
Oct 22, 2008 at 9:10 AM
I don't think it's possible because the OracleProvider itself doesn't support passing refcursors as input parameters. 

"To execute a stored procedure that returns REF CURSORs, you must define the parameters in the OracleParameterCollection with an OracleType of Cursor and a Direction of Output. The data provider supports binding REF CURSORs as output parameters only. The provider does not support REF CURSORs as input parameters."
http://msdn.microsoft.com/en-us/library/bw9eczdk.aspx