In order to call a stored procedure using the hibernate , define a named query for a persistent class mapping document. Then call the named query from your java application .Example is given in the Hi...
As per sql-->create a procedure in your sql by using the following code.create or replace procedure first-procedure(x in number,y out number)beginy:=x*x;end; write your sql connection code in ...