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

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

     [ http://216.121.112.228/browse/NH-2631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fabio Maulo updated NH-2631:
----------------------------

    Component/s: DataProviders / Dialects
        Summary: Selectable stored procedure with ORACLE  (was: Problem in executing stored procedure with NHibernate 3 as well.)

> 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