Hi,
I wonder how to handle no_data_found exception in 'for c in .... loop' loop statement.
In following code program does not go to exception block.
BEGIN
FOR C IN
(SELECT 'x' FROM DUAL WHERE 1=2)
LOOP
DBMS_OUTPUT.PUT_LINE('Here we go with some data');
END LOOP;
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('No data');
END;
Do I need to use a variable or there is some cursor attribute.
I work on DB version 11.2.0.2.0.
Thank you,
Marcin