Beginner |
 |
Joined: Tue Aug 26, 2008 4:24 pm Posts: 29
|
How to call a stored procedure? I have read some questions in this forum and I got this:
From my java code I could do:
Query query = sesion.getNamedQuery("procedure_SP");
And in the hbm file:
<sql-query name="procedure_SP" callable="true"> <return alias="InfoUser" class="mx.uam.hibernate.InfoUser"/> {call selectTestInfoUser_sp(?)} </sql-query>
1. is this right? 2.If my store procedure has 1 one parameter out and three parameters in in this order, this line {call selectTestInfoUser_sp(?)} should turn into ?
Thanks
|
|