Calling Stored Procedure From Hibernate With Java, Hibernate Hibernate How To Index

Hello,
First of all, congratulations to keep a lot of documentation about hibernate in one place: it's help a lot !
I need to call an stored procedure in oracle from Hibernate (see bellow) that has 1 input parameter and 2 return values. I'm receiving and error from Oracle (invalid column index). Any help is appreciated.
Thanks in advance !!!

HBM file
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class name="br.com.gppg.dto.csep_Busca_Vinc_Matr">
<cache usage="read-only"/>
<id name="usuario" column="P_USERID"/>
<property name="vinculo" column="P_VINCULO"/>
<property name="matricula" column="P_MATRICULA"/>
<loader
query-ref="CSEP_BUSCA_VINC_MATR"/>
</class>
<sql-query name="CSEP_BUSCA_VINC_MATR" callable="true" >
<return alias="vinc_matr" class="br.com.gppg.dto.csep_Busca_Vinc_Matr" lock-mode="read">
<return-property name="vinculo" column="P_VINCULO"/>
<return-property name="matricula" column="P_MATRICULA"/>
</return>
{call CSEP_BUSCA_VINC_MATR(:ID_USUARIO,{vinc_matr.vinculo},{vinc_matr.matricula})}
</sql-query>
</hibernate-mapping>

Code to call it:

session = HibernateUtil.currentSession();
Query query = session.getNamedQuery("CSEP_BUSCA_VINC_MATR");
query.setString("ID_USUARIO", "tstgp");


Here is error message:
INFO [STDOUT] Hibernate: {call CSEP_BUSCA_VINC_MATR(?,{vinc_matr.vinculo},P_MATRICULA)}
WARN [JDBCExceptionReporter] SQL Error: 17003, SQLState: null
ERROR [JDBCExceptionReporter] Invalid column index

Posted by Andre on Sunday, 03.2.08 @ 19:03pm | #51028