I'm rarely inquire here so If I need a code tag, someone can remind me how it's done. I need to know if the first nested block goes to exception for let's say, Too Many Rows or No Data, will the loop reset and the second nested block at the same level be skipped all together? Thanks in advance.
DECLARE
i NUMBER := 0;
--
CURSOR c_get_cl_id IS
SELECT bla, bla, bla from xyz
WHERE col = 'a';
BEGIN
FOR cl_id_cur IN c_get_cl_id
LOOP
BEGIN
O O O
O O O
Exception
O O O
END;
BEGIN
O O O
O O O
Exception
O O O
END;
END LOOP;
Exception
O O O
END;