Can I reset cursor’s position to the beginning?

you need to declare your cursor as scroll, like this

declare c scroll cursor for (select statement); 

then at any time for locating to the first just use the following

fetch first from c;