Home

Block start and end labels should match

Rule description

  • Block start and end labels should match

 

Non-compliant Code Example

<<outerone>>  --Non complaint code (Block start and end label are not matching)
BEGIN
   DECLARE
      abc INTEGER;
   BEGIN
      IF abc = outerone.abc THEN  -- refers to global abc
         NULL;
      END IF;
   END;
END innerone; 

Compliant Code Example

<<outerone>>   --Complaint code (Block start and end labels are same)
BEGIN
   DECLARE
      abc INTEGER;
   BEGIN
      IF abc = outerone.abc THEN  -- refers to global abc
         NULL;
      END IF;
   END;
END outerone; 
Visual Expert 2020
 VEPLSQLRULE23