Answer the question
In order to leave comments, you need to log in
How to overcome the error cursor "" is not positioned on a row?
I create a cursor
OPEN curs1 FOR SELECT * FROM leads_client WHERE status = 0;
UPDATE leads_client SET status = 1 WHERE CURRENT OF curs1;
loop
fetch curs1 into r;
if(r.id is nOT NULL) THEN
id := r.id;
return next;
END IF;
if not(found) then exit; end if;
end loop;
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question