Hi,
For this use Callable cstmt as
CallableStatement cstmt = null;
or
CallableStatement cstmt = conn.prepareCall("{call Proc_name(?,?,?,?)}");
then set the IN params in the proc using set methods as setInt ,setString
and out as
cstmt.registerOutParameter(2, java.sql.Types.INTEGER);
(here 2 -> parameterInedex and java.sql.Types.INTEGER as -> sql type)
there are methods also registering the out parameters see it in java
doc then execute the proc as
cstmt.execute();
In the end close cstmt , conn in the finally block
thanks
champak