First row of ref cursor

[mjm461]

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.

[hspc]

Hi..
Depending on youe cursor type, you can use :

FETCH FIRST FROM REFCUR