title: Does Stored Procedure works with NHibernate to return out parameter/ref_cursor or I need to Write Function to this
body: <p>Does Stored Procedure works with NHibernate to return out parameter/ref_cursor or I need to Write Function to this.Because it is working with function not with Stored Proc</p>
  
  <p>@Diego:  <strong>Mapping File</strong><br>
   &lt; ?xml version="1.0" encoding="utf-8" ?><br>
     &lt; hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"><br>
       &lt; class name="DomainObject.Employee,DomainObject" table="Employee"><br>
         &lt; id name="EmployeeId" column="Emp_ID" type="int" unsaved-value="0"><br>
           &lt; generator class="native"><br>
            &lt; /generator><br>
         &lt; /id><br>
      &lt; property name="EmployeePassword" column="EMP_PASSWORD" type="string"/><br>
      &lt; property name="EmployeeName" column="EMP_NAME" type="string"/><br>
      &lt; property name="TeamAssociatedWith" column="TEAM_ASSOCIATED_WITH" type="int"/><br>
      &lt; property name="IsCaptain" column="IS_CAPTAIN" type="string"/><br>
      &lt; property name="NumberOfMOM" column="NO_OF_MOM" type="int"/><br>
      &lt; property name="Balance" column="BALANCE" type="int"/><br>
    &lt; /class>  </p>
  
  <p>&lt; sql-query name="selemployee" callable="true" ><br>
      &lt; return class="DomainObject.Employee,DomainObject"><br>
        &lt; return-property name="EmployeeId" column="Emp_ID"/><br>
        &lt; return-property name="EmployeeName" column="EMP_NAME"/><br>
        &lt; return-property name="EmployeePassword" column="EMP_PASSWORD"/><br>
        &lt; return-property name="TeamAssociatedWith" column="TEAM_ASSOCIATED_WITH"/><br>
        &lt; return-property name="IsCaptain" column="IS_CAPTAIN"/><br>
        &lt; return-property name="NumberOfMOM" column="NO_OF_MOM"/><br>
        &lt; return-property name="Balance" column="BALANCE"/><br>
      &lt; /return><br>
      { ? = call GETPERSONTEST}<br>
    &lt; /sql-query><br>
  &lt; /hibernate-mapping>  </p>
  
  <p><strong>Stored Procedure Oracle</strong><br>
  create or replace PROCEDURE GETPERSONTEST(io_cursor out SYS_REFCURSOR)<br>
  IS<br>
  BEGIN<br>
  OPEN io_cursor FOR  SELECT   EMP_ID,EMP_NAME,EMP_PASSWORD,TEAM_ASSOCIATED_WITH,IS_CAPTAIN,NO_OF_MOM,BALANCE  FROM employee  ;<br>
  END GETPERSONTEST;   </p>