Hibernate calls the Oracle Stored Procedure

We only need to bypass hibernate to call the jdbc API. Of course, the transaction is managed by the hibernate industry:
Assume that the following stored procedure is created:

Create or replace procedure batchUpdateCustomer (p_age in number)
Begin
Update MERs set AGE = AGE + 1 where AGE> p_age;
End;

There is a parameter p_age In the stored procedure, which indicates the customer's age. The application can call the stored procedure as follows:
Code content
Tx = session. beginTransaction ();
Connection con = session. connection ();
String procedure = "{call batchUpdateCustomer (?) }";
CallableStatement cstmt = con. prepareCall (procedure );
Cstmt. setInt (); // set the age parameter to 0.
Cstmt.exe cuteUpdate ();
Tx. commit ();