This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes how to handle when procedure returns more than one resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to handle when procedure returns more than one resultset" Watch "how to handle when procedure returns more than one resultset" New topic
Author

how to handle when procedure returns more than one resultset

Praveen palukuri
Ranch Hand

Joined: Feb 10, 2005
Posts: 65
hi,
can we handle when a procedure returns more than one resultset.if so, please help me.

Thank u.
Evgeniy Bulanov
Greenhorn

Joined: Dec 19, 2005
Posts: 23
and what's a problem? just register more than one output parameters. And execute the procedure ...


Computers are like air conditioners - They stop working properly when you open Windows
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703
    
    5

I think your asking about multiple result sets, not multiple columns in a single result set.

In that case, you have to make sure the database/driver support this fluidly. If so, you can use getMoreResults() and getResultSet() to iterate through additional results sets.

I refer you to the following IBM article:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.java/bjnkmstr31.htm

Which states:

[ December 19, 2005: Message edited by: Scott Selikoff ]

My Blog: Down Home Country Coding with Scott Selikoff
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to handle when procedure returns more than one resultset
 
Similar Threads
Result
calling SQL Server stored procedures
getting empty resultset
Executing procedure in Hibernet with more than one out parameters
Diff bet execute() and executeQuery()