Multiple Result Sets

[Jennifer Sohl]

I have an app that is returning 5 result sets. When I run this stored procedure outside of my java app, it seems to work okay. However when I execute query it is doing something strange. The first result set will always only return one row. However the others could have multiple rows. The first time I did a cs.executeQuery().... worked fine. To read the next result set I did

cs.getMoreResults();
rs = cs.getResultSet();
while(rs.next()) {
do stuff
}

For some reason it is reading the result set as if it has 2 rows.... when it actually only has one row when I run it outside of the java app. Any ideas? I'm sure it's something stupid I've done, but I just can't seem to put my finger on it.
Thanks for any help you can give me!

[Meet Gaurav]

The callable statement will return the array. Just iterate it and collect the result sets.