Store Procedure in Hibernate

maximus · **Joined:** Tue Oct 30, 2007 12:08 pm **Posts:** 1

Hello!
Is it possible to access stored procedure with out parameter in Hibernate?
My stored procedure is like this:

Quote:

create or replace procedure test1 (pi_1 in number,pi_2 in number, po_1 out number)
is
vi_1 number(4) default pi_1;
vi_2 number(4) default pi_2;
v_err varchar2(1000);
p_rc varchar2(1000);

begin
po_1:= vi_1 + vi_2;

EXCEPTION
WHEN OTHERS THEN
v_err:=' ERR: An error occurred with info :'||SQLCODE||' errm '||SQLERRM||' ';
dbms_output.put_line(v_err);
p_rc:=SQLCODE;
end test1;

How should I declare it in xml file?

max · **Posted:** Mon Nov 05, 2007 1:22 pm

no it is not.

kid1125 · **Joined:** Wed Oct 31, 2007 5:36 pm **Posts:** 13

See section 16.2.2

http://www.hibernate.org/hib_docs/reference/en/html/querysql.html

out-parameter must be first parameter.

max · **Posted:** Tue Nov 06, 2007 3:40 am

...the out parameter only have to be this returned one out parameter in case of Oracle - oracle is the only SP enabled db that doesn't support returning a resultset directly from a SP.

Arbitrary out parameters are not supported.