Search code examples
.netoracleenterprise-library

What is Oracle RefCursor type equavalent in System.Data.DbType enum in C#?

I'm programming a DataAccess code using Microsoft Enterprise Library, and I'm connecting to Oracle Database. When I try to call a Stored Procedure which expecting an out parameter of type RefCursor I can't pass it this type since the only available types are these types in "System.Data.DbType". So which type should I pickup for Oracle "RefCursor" DbType?

Solution

  • Put a null placeholder: http://tiredblogger.wordpress.com/2007/08/27/enterprise-library-and-oracle-stored-procedure-record-sets/

    You have to use a parameter array list, you cannot use the AddParameter.