Connection conn = ...;
java.sql.CallableStatement cstmt = conn.prepareCall("{?=call sp_name(?)}");
cstmt.setString(2, "xxx");
cstmt.registerOutParameter(1, java.sql.Types.INTEGER);
ResultSet rs = cstmt.executeQuery();
while (rs.next()) {...}
cstmt.getInt(1); // Retrieve procedure's return value