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

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.
0 Comments  (click to add your comment)
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

About | Sitemap | Contact