Home
END statements of labeled loops should be labeled
Rule description
- END statements of labeled loops should be labeled
Non-compliant Code Example
BEGIN
<<ForLoopOnCustomer>>
FOR i IN 1 .. CUSTOMER_TABLE.COUNT --Non compliant code (END statements of labeled loops is not labeled)
LOOP
IF CUSTOMER_TABLE(i) IS NOT NULL THEN
DBMS_OUTPUT.PUT( i || ' = (' || CUSTOMER_TABLE(i).Name || ', ' || CUSTOMER_TABLE(i).PhoneNumber || ')' );
ELSE
DBMS_OUTPUT.PUT( i || ' IS NULL' );
END IF;
END LOOP;
COMMIT;
END;
Compliant Code Example
BEGIN
<<ForLoopOnCustomer>>
FOR i IN 1 .. CUSTOMER_TABLE.COUNT --Compliant code (END statements of labeled loops is labeled)
LOOP
IF CUSTOMER_TABLE(i) IS NOT NULL THEN
DBMS_OUTPUT.PUT( i || ' = (' || CUSTOMER_TABLE(i).Name || ', ' || CUSTOMER_TABLE(i).PhoneNumber || ')' );
ELSE
DBMS_OUTPUT.PUT( i || ' IS NULL' );
END IF;
END LOOP ForLoopOnCustomer;
COMMIT;
END;