CallableStatement example

Presented below is an example of CallableStatement.

Code:

---

String query = "begin thePackage.theProcedure(?,?,?); end;";
CallableStatement cs = conn.prepareCall(query);
cs.setString(1, "string parameter");
cs.setInt(2, 1);
cs.registerOutParameter(2, Types.INTEGER);
cs.registerOutParameter(3, Types.INTEGER); 
cs.execute();

int output_parm2 = cs.getInt(2);
int output_parm3 = cs.getInt(3);

---