How do I go to the next record in an Oracle PL/SQL Loop?

First off, you probably need to initialze your counter outside the loop. As for getting the next record, execute another FETCH at the end of the loop. It will then retest whetherNOTFOUND occured and, if not, restart at the beginning of the loop.