Cursor FOR loop vs. open/fetch/loop

[akkerend]

Use PL/SQL block with exception handler for your -9100 error inside the loop:
DECLARE
CURSOR C1 IS ...
EXCEPTION ...
PRAGMA ...
BEGIN
FOR r1 IN c1
LOOP
BEGIN
...
EXCEPTION
WHEN e_DB2_error THEN
...
END;
END LOOP;
END;