File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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