posted 21 years ago
Hai
I executed a query to get a ResultSet1 using some connection and statement settings. Using same settings when i executed some other query first result set in automatically closed. This seems to be default behaviour.
My requirement is like follows.
--Execute some stored procedures.
-- Then process each result set
using same connection and statement. Problem here is once i run some query previous Result set is getting closed and I am unable to do anything with previous resultset later.
Can anybody suggest how best I can solve this problem following same sequence of steps?
Awaiting your valuable inputs.
Thanks and Rgds
Manohar