JDBC Call Store Procedure

 

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