we have a stored procedure with multiple select in it.
Select a,b,c from table1
Select f,g,h from table2
Select j,k,l from table3
Sometimes select no 2 will not return any values.
when this happens we get only 2 result sets using CallableStatement getMoreResults method.
it seems that if a select doesn't return something it will not have a corresponding resultset.
On 2000 (driver + server) version we got an empty resultset for this situation.
Is there any way to have the same behaivor with 2005 ? We tryed with 1.2 and 2.0 jdbc driver.
View Complete Post