dcsimg

Could we get sample code for retrieving more than one parameter from a stored procedure?

Created May 4, 2012

Joe Sam Shirah

Assume we have a stored procedure with this signature:

MultiSP (IN I1 INTEGER, OUT O1 INTEGER, INOUT IO1 INTEGER)

The code snippet to retrieve the OUT and INOUT parameters follows:

	CallableStatement cs = connection.prepareCall( "(CALL MultiSP(?, ?, ?))" );
	cs.setInt(1, 1); // set the IN parm I1 to 1
	cs.setInt(3, 3); // set the INOUT parm IO1 to 3

	cs.registerOutParameter(2, Types.INTEGER); // register the OUT parm O1
	cs.registerOutParameter(3, Types.INTEGER); // register the INOUT parm IO1

	cs.execute();
	int iParm2 = cs.getInt(2);
	int iParm3 = cs.getInt(3);
	cs.close();
The code really is just additive; be sure that for each IN parameter that setXXX() is called and that for each INOUT and OUT parameter that registerOutParameter() is called.