Oracle stored procedure with Ref Cursor out

Yes, notwithstanding NH-2027.

Is this fix available in 2.1.2GA?

Added support for Oracle stored procedures. Note, fix is for OracleDataClient.

Example mappings and PL/SQL can be found at:

http://nhibernate.svn.sourceforge.net/viewvc/nhibernate/trunk/nhibernate/src/NHibernate.Test/SqlTest/Custom/Oracle/Mappings.hbm.xml?view=markup
http://nhibernate.svn.sourceforge.net/viewvc/nhibernate/trunk/nhibernate/src/NHibernate.Test/SqlTest/Custom/Oracle/StoredProcedures.hbm.xml?view=markup

Any chance of increasing the priority of this issue?

Isn't it just a matter of adding the required code to the InitializeParameter() method of the Oracle Driver class to properly initialize a ref_cursor parameter. You would most likely have to use a combination of name and sqlType to determine what is a ref_cursor.

Something like the following:

private const string RefCursorPrefix = "cur_";

protected override void InitializeParameter(IDbDataParameter dbParam, string name, SqlType sqlType)
{
if (sqlType.DbType == DbType.Guid)
{
base.InitializeParameter(dbParam, name, GuidSqlType);
}
else if (sqlType.DbType == DbType.Object && name.StartsWith(RefCursorPrefix))
{
base.InitializeParameter(dbParam, name, ((OracleParameter)dbParam).OracleDbType = OracleDbType.RefCursor);
}
else
{
base.InitializeParameter(dbParam, name, sqlType);
}
}