This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Stored procedure question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Stored procedure question" Watch "Stored procedure question" New topic

Stored procedure question

Atul Mishra
Ranch Hand

Joined: Jun 08, 2006
Posts: 140
All, I am new to accessing Stored procedures using jdbc, I have a stored procedure which returns multiple resultsets and each result set is stored in a PL?sql table.

How can I retrieve these ?
Any links/code samples please help
Leandro Dantas

Joined: Feb 01, 2007
Posts: 14

CallableStatement cstmt;
ResultSet rs;
int i;
String s;
cstmt.execute(); // Call the stored procedure 1
rs = cstmt.getResultSet(); // Get the first result set 2
while ( { // Position the cursor 3
i = rs.getInt(1); // Retrieve current result set value
System.out.println("Value from first result set = " + i);
// Print the value
cstmt.getMoreResults(); // Point to the second result set 4a
// and close the first result set
rs = cstmt.getResultSet(); // Get the second result set 4b
while ( { // Position the cursor 4c
s = rs.getString(1); // Retrieve current result set value
System.out.println("Value from second result set = " + s);
// Print the value
rs.close(); // Close the result set
cstmt.close(); // Close the statement

Best regards.
I agree. Here's the link:
subject: Stored procedure question
It's not a secret anymore!