[nhibernate-issues] [JIRA] Commented: (NH-847) Oracle stored procedure with Ref Cursor out

[NHibernate J. <nh...@gm...>]

    [ http://nhjira.koah.net/browse/NH-847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18414#action_18414 ] 

Matthew Griffore commented on NH-847:
-------------------------------------

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);
        }
}

> Oracle stored procedure with Ref Cursor out
> -------------------------------------------
>
>                 Key: NH-847
>                 URL: http://nhjira.koah.net/browse/NH-847
>             Project:  NHibernate
>          Issue Type: Improvement
>          Components: Core
>    Affects Versions: 1.2.0.Beta2
>            Reporter: Brian Choi
>            Priority: Minor
>         Attachments: SqlTests-Oracle-OracleCustomSQLFixture-10g-TestResult.zip
>
>
> http://forum.hibernate.org/viewtopic.php?t=968269

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://nhjira.koah.net/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira