How to call a oracle stored procedure from Hibernate?

balak · **Joined:** Wed Jul 26, 2006 5:27 am **Posts:** 3

Can somebody give me a simple example as to how to call a oracle stored procedure and a named sql query from hibernate?

Thanks,
balak

QWERTY? · **Joined:** Thu Jun 22, 2006 12:11 am **Posts:** 14

did you figure it out, im currently trawling through and I cant really find a simple way to do it, though my understanding of hibernate is minimal

QWERTY? · **Joined:** Thu Jun 22, 2006 12:11 am **Posts:** 14

basically i have the following defined procedure

Code:

Procedure get_line_setup(sp_coat_tp in Varchar2,
          sp_iron_cd in Varchar2,
                         sp_bmt     in number,
                         sp_width   in number,
                         sp_Induction_ind out varchar2,
                         sp_fclno     out number,
                         sp_sub_fcl_cd out varchar2,
                         sp_delta_t   out number,
                         sp_ind_pwr_setting out number,
          sp_Line_speed out number,
                         sp_ctwgt   in number := null,
                         sp_prot_cd in Varchar2 := null,
                         sp_ind_override in varchar2 := null)

and i just want to get the out values

max · **Posted:** Thu Aug 24, 2006 3:33 am

and if you had read the docs you will see the following line:

"The stored procedure/function must return a resultset" and as a consequence out parameters are also not suppored.