qball
06-21-2001, 04:00 PM
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.
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.