Home

END statements of labeled blocks should be labeled

Rule description

  • END statements of labeled blocks should be labeled

 

Non-compliant Code Example

<<outerone>>   
BEGIN
   DECLARE
      abc INTEGER;
   BEGIN
      IF abc = outerone.abc THEN  -- refers to global abc
         NULL;
      END IF;
   END;
END;            --Non compliant code (END statements of labeled blocks is not labeled)

Compliant Code Example

<<outerone>> 
BEGIN
   DECLARE
      abc INTEGER;
   BEGIN
      IF abc = outerone.abc THEN  -- refers to global abc
         NULL;
      END IF;
   END;
END outerone;   --Compliant code (END statements of labeled blocks is labeled)
Visual Expert 2020
 VEPLSQLRULE89