Instead of trying to get this piece of code to run -- which I suspect is something that you've taken over from a departed developer or consultant -- see if you can write something from scratch that does just the first result set.

Get that working properly, learn from it, and then go on to the next result set.