how to handle when procedure returns more than one resultset

[Praveen palukuri]

hi,
can we handle when a procedure returns more than one resultset.if so, please help me.

Thank u.

[Evgeniy Bulanov]

and what's a problem? just register more than one output parameters. And execute the procedure ...

[Scott Selikoff]

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:

   1. Invoke the Statement.execute method or PreparedStatement.execute method to call
      the stored procedure.  Use PreparedStatement.execute if the 
      stored procedure has input parameters.
   2. Invoke the getResultSet method to obtain the first result set, which is in a ResultSet object.
   3. In a loop, position the cursor using the next method, and retrieve data from
      each column of the current row of the ResultSet object using getXXX methods.
   4. If there are n result sets, repeat the following steps n-1 times:
         1. Invoke the getMoreResults method to close the current 
            result set and point to the next result set.
         2. Invoke the getResultSet method to obtain the next result 
            set, which is in a ResultSet object.
         3. In a loop, position the cursor using the next method, 
            and retrieve data from each column of the current row 
            of the ResultSet object using getXXX methods.

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