How to retrieve multiple result set of a stored procedure

Hi,

How can we retrieve multiple result set of a stored procedure? My requirement is that I got a stored procedure that returns two sets of records. When I try to retrieve the data, I am getting only the first set of records and the second set is ignored.

Any help will be greatly appreciated.

Thanks

Sinash Shajahan

I came to know that we need to use ‘nextResult()’ which advances the reader to the next result when reading the results of a batch of statements. I.e. when there are multiple result sets returned by the query. But I am not able to get it working. Can anybody provide me with an example