But I get ResultsetObj as null...and I know that stored produre returns valid data for 2nd cursor...as I have confirmed it by running the procedure in stored procedure builder. I'm using IBM DB2 7.0
I'll be very glad, If anybody can give me the clarification.
Post by:Julian Kennedy
, Ranch Hand
A couple of questions and suggestions:
What happens if you swap the cursors round in your SP? Does the first ResultSet then contain the right results?
I've experienced problems in the past with Sybase drivers whereby if you make any changes to the statement's parameters after having executed it (or even access output parameters, I think) then the statement loses (or resets) its ResultSet. Could that be your problem?
Is there a logical difference between an empty ResultSet and a null one, i.e. if your query returns zero rows, is ResultSet null or just created empty? Obviously I realise there's a physical (Java) difference.
Try 100 things. 2 will work out, but you will never know in advance which 2. This tiny ad might be one: