I have written a procedure in MS SQL. In this procedure, I've created a temp table and put data inside this table.
I do a select * from this temp table and then drop the table.
Now, I want to access this result set in JDBC, but it gives me an error "Statement does not return any result set". If I run the procedure from within SQL itself, the result set comes up fine.