calling procedures in java

to use proecedures in the database we need to use the following code

need to register the out parameters to the callable statements.

st.registerOutParameter(8, java.sql.Types.INTEGER);

8 is the parameter position name
java.sql.Types.INTEGER is type of the parameter

st.execute();
st.getInt(8); --- this statement returns the out parameter values