This loops fine, except it newer gets to LOG POINT 2 or LOG POINT 3

LOG POINT 1, does not occur at last record in cursor, which is OK.

proc dies with, error caught in java:
No data - zero rows fetched, selected, or processed

Don't see why is that.



OPEN cur;

FETCH cur INTO c_tmp_str;

WHILE NOT eof DO


SET i_optional_inf = 0 + c_tmp_str;


insert ignore into galery_optional_inf
(
id_galery,
id
)
VALUES
(
i_id_galery,
i_optional_inf
);

FETCH cur INTO c_tmp_str;
//LOG POINT 1
END WHILE;

//LOG POINT 2

CLOSE cur;

//LOG POINT 3

ahh , forgot to add:


DECLARE CONTINUE HANDLER FOR NOT FOUND SET eof = 1;

Yeah, it's a pretty ridiculous syntax, isn't it? You'd think we could simply do something like

DO
SELECT ...;
UNTIL NOT FOUND;

or something along those lines.