While i call the procedure by hibernate, i am getting the error like below

java.lang.IllegalArgumentException: callable not yet supported for native queries
at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:147)

Code base and procedure


Oracle Procedure

CREATE OR REPLACE PROCEDURE PR_COMPANY_DETAILS2 (OUT_RESULT out SYS_REFCURSOR) as
BEGIN
open OUT_RESULT for
select C.COMPANY_NAME as COMPANY_NAME from COMPANY C where c.COMPANY_ID=1;
END;
/
exec PR_COMPANY_DETAILS2;


code

public void callProcedure(){
try{
Session session = SessionManager.currentSession();
Transaction tx = session.beginTransaction();
Query query = session.getNamedQuery("loadCompanyName");
int value = query.executeUpdate();
System.out.println(" OutPUT :"+value);
tx.commit();
}catch (Exception e) {
e.printStackTrace();
}
}

in .hbm.xml file

<sql-query name="loadCompanyName" callable="true">
<return class="com.template.pojos.CompanyDetailsBean">
<return-property name="companyName" column="COMPANY_NAME"/>
</return>
{ call PR_COMPANY_DETAILS2(?) }
</sql-query>



please help me to solve the issue

I solve my similar problem delete the callable properties. My problem cause file is:

<sql-query name="AddLecturer" callable="true">
<return alias="lecturer" class="entities.dao.Lecturer"/>
<![CDATA[CALL AddLecturer(:pLecturerName)]]>
</sql-query>


And I delete the callable ="true" line and problem solved, I don't understand why? Maybe someone explain it, Good luck.

This was my solution.

<sql-query name="AddLecturer">
<return alias="lecturer" class="entities.dao.Lecturer"/>
<![CDATA[CALL AddLecturer(:pLecturerName)]]>
</sql-query>

Can you please share your SP details. Because I have same problem. I dontknow how to pass refcursor to stored procedure, if I use the code written by you, it is still telling that number of arguments are less than expected. Any body did solve this issue yet, or is it fixed by nHibernate 2.1.2 GA

hi all i have a same problem.