Change of variables by continue handler not recognized by debugger
I use continue handler to handle the end of row in a cursor in an stored proc. While debugging the debugger does not recognize when the handler fires an changes a variable. The debugger-value-tooltip for that variable still displays the old, unchanged value after the the handler fired.
3
votes
Philipp Stiefel
shared this idea
Unfortunately, we can not fix the issue for technical reasons.
Workaround:
Please use BEGIN…END block around the handler statement.
For example:
DECLARE CONTINUE HANDLER FOR NOT FOUND
BEGIN
SET l_nomore = 1;
END;