Home

Block labels should appear on the same lines as END

Rule description

  • Block labels should appear on the same lines as END

 

Non-compliant Code Example

<<outerloop>>
DECLARE
   abc INTEGER;
BEGIN
   DECLARE
      abc INTEGER;
   BEGIN
      IF abc = outerloop.abc THEN  -- refers to global abc
         NULL;
      END IF;
   END;
END 
outerloop; --Non complaint code (Block label is not placed in the same line as END)

Compliant Code Example

<<outerloop>>
DECLARE
   abc INTEGER;
BEGIN
   DECLARE
      abc INTEGER;
   BEGIN
      IF abc = outerloop.abc THEN  -- refers to global abc
         NULL;
      END IF;
   END;
END outerloop; --Complaint code (Block label is placed in the same line as END)
Visual Expert 2020
 VEPLSQLRULE41