[nhibernate-issues] [NHJIRA] Commented: (NH-2631) Selectable stored procedure with ORACLE

[Anupam M. (JIRA) <nh...@gm...>]

    [ http://216.121.112.228/browse/NH-2631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20859#action_20859 ] 

Anupam Mishra commented on NH-2631:
-----------------------------------

I have replicated the same example.But still it is not working with Oracle 10 g .

It is giving following error

Exception:Could not create the driver from NHibernate.Driver.OracleDataClientDriver.

Inner Message:Unable to find the requested .Net Framework Data Provider.  It may not be installed.

<session-factory>
    <!--<property name="hibernate.connection.release_mode">on_close</property>-->
    <property  name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
    <property name="dialect">NHibernate.Dialect.Oracle10gDialect </property>
</session-factory>

Can u please help

> Selectable stored procedure with ORACLE
> ---------------------------------------
>
>                 Key: NH-2631
>                 URL: http://216.121.112.228/browse/NH-2631
>             Project:  NHibernate
>          Issue Type: Bug
>          Components: Core, DataProviders / Dialects
>    Affects Versions: 3.0.0.GA
>            Reporter: Anupam Mishra
>            Priority: Minor
>         Attachments: Stored Procedure Problem.txt
>
>
> Following is my Stored Procedure:
> create or replace PROCEDURE GETPERSONTEST (io_cursor   IN OUT   sys_refcursor) 
> IS
> BEGIN 
> OPEN io_cursor FOR 
>       SELECT EMP_ID,EMP_NAME,EMP_PASSWORD,TEAM_ASSOCIATED_WITH,IS_CAPTAIN,NO_OF_MOM,BALANCE  FROM employee  ; 
> END GETPERSONTEST; 
> Nhibernate Mapping:
>  <sql-query name="selemployee" callable="true">
>     <return class="DomainObject.Employee,DomainObject" >
>       <return-property name="EmployeeId" column="Emp_ID"/>     
>       <return-property name="EmployeeName" column="EMP_NAME"/>
>       <return-property name="EmployeePassword" column="EMP_PASSWORD"/>
>       <return-property name="TeamAssociatedWith" column="TEAM_ASSOCIATED_WITH"/>
>       <return-property name="IsCaptain" column="IS_CAPTAIN"/>
>       <return-property name="NumberOfMOM" column="NO_OF_MOM"/>
>       <return-property name="Balance" column="BALANCE"/>
>     </return>
>   {call GETPERSONTEST(?)}
>   </sql-query>
> Problem in Executing throwing following exception 
> Exception stack trace is attached.
>  could not execute query
> [ {call GETPERSONTEST(@p0)} ]
> It will be a great help if suggest some approach to make it work.
> As this problem is coming with every version of NHibernate.Create ,Update and Delete is working fine only facing this problem in case of select.

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