How do I receive a ResultSet from a stored procedure?

Joe Sam Shirah

Stored procedures can return a result parameter, which can be a result set. For a discussion of standard JDBC syntax for dealing with result, IN, IN/OUT and OUT parameters, see Stored Procedures. In addition, see How do I execute stored procedures?, How can I get data from multiple ResultSets?, Could we get sample code for retrieving more than one parameter from a stored procedure?.