dcsimg

Can you scroll a result set returned from a stored procedure?

Joe Sam Shirah

A CallableStatement is no different than other Statements in regard to whether related ResultSets are scrollable. You should create the CallableStatement using Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency).

For more information, see 7.1.1 Creating a CallableStatement Object, Can a stored procedure return an updatable ResultSet?, and How do I receive a ResultSet from a stored procedure?.