Hello All.... I need to execute this stored procedure using hibernate. I am new to hibernate and need to know what would be the exact steps to execute this very basic stored procedure.

The procedure takes two parameters and outs two parameters:

CREATE OR REPLACE procedure SAMPLE_PROC (P_PARA1 number, P_PARA2 varchar2, P_PARA3 OUT number, P_PARA4 OUT varchar2)
as
begin
P_PARA3:=P_PARA1+10;
P_PARA4:=P_PARA2||'10';
end;
/

Please help.

I am new to Hibernate as well so maybe I just haven't thought it through all the way, but is there even any benefit to running a stored procedure with Hibernate?? I can't really think of one...

Hi I think a good starting point for you would be one of the last posts of this thread by oldkeybo :

http://forum.hibernate.org/viewtopic.php?t=960553

to pass parameters to your procedure you need to change this line in the mappping file:



into


and in your launching code you should have something like this:


Hope this helps.
Peter

You can read in more detail about Hibernate Document Reference.

At here, I will show you a example:

<sql-query name="IndiceHistoricoMercado" callable="true">
<return-scalar column="" type="string"/>
call SAMPLE_PROC :var1, :var2, :var3, :var4
</sql-query>

The sentence mentioned is include in some your hibernate mappings files.

Then, do someting with what Pi sayed to you, call NamedQuery then set all variables you need, and so on.

Waiting for your good result.

Hi neketsushonen:

I tried to call the procedure in your way but it didn't work. I had to put the variables into paranthesis:
call SAMPLE_PROC (:var1)

So, that did work fine now?