JDBC: Getting multiple ResultSets from a Stored Proc
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.
New Security Features Planned for Firefox 4
Another Laptop Theft Exposes 21K Patients' Data
Oracle Hits to Road to Pitch Data Center Plans
Microsoft Preps Array of Windows Patches
Microsoft Nears IE9 Beta With Final Preview
Simplified Analytics Improve CRM, BI Tools
Android Passes RIM as Top Mobile OS in 2Q
VMware Updates Hyperic System Management
File Monitoring Key to Enterprise Security
LinkedIn Snaps Up SaaS Player mSpoke