CallableStatement example

[Java Tip]

Presented below is an example of CallableStatement.

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);