mjm461
March 18th, 2005, 08:27 AM
I have something like this...
mycursor REFCUR;
OPEN mycursor FOR
Select a, b,c from yada;
I loop through the the cursor using fetch 1 time... I want to loop through the cursor a second time, however the cursor is pointing at the last row. Is there a way to reset it to the first row again without doing the query all over.
mycursor REFCUR;
OPEN mycursor FOR
Select a, b,c from yada;
I loop through the the cursor using fetch 1 time... I want to loop through the cursor a second time, however the cursor is pointing at the last row. Is there a way to reset it to the first row again without doing the query all over.