How can I do to declare a CURSOR inside a PROCEDURE ? I think I'm using a wrong syntax.

Thanks !!!

Hi,

CREATE PROCEDURE foreach_example()
DEFINE i, j INT;
FOREACH cur1 FOR SELECT c2, c3 INTO i, j FROM tab
IF j > 500 THEN
DELETE FROM tab WHERE CURRENT OF cur1;
CONTINUE FOREACH;
END IF
UPDATE tab SET c2 = c2 + 5 WHERE CURRENT OF cur1;
END FOREACH
END PROCEDURE

Regards,
Shriyan