A friend of mine related a question he was asked whilst being teched out on JDBC. He was asked how does one get multiple ResultSets from a stored procedure call.

The answer is to use a CallableStatement, but therein lies MY question. How does one create a stored procedure that returns multiple result sets? and who wants to do this? Seems more logical and manageable to use multiple stored procs and multiple statements.