Description
Environment
Attachments
Activity
Richard Brown December 2, 2009 at 8:05 AM
Yes, notwithstanding NH-2027.
Matthew Griffore November 30, 2009 at 8:54 AM
Is this fix available in 2.1.2GA?
Richard Brown October 26, 2009 at 4:24 AM
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
Matthew Griffore October 9, 2009 at 8:32 AM
Any chance of increasing the priority of this issue?
Matthew Griffore July 13, 2009 at 8:46 AM
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);
}
}
http://forum.hibernate.org/viewtopic.php?t=968269