Home

Improper constraint forms should not be used

Rule description

  • Improper constraint forms should not be used

 

Non-compliant Code Example

<<outerloop>>
BEGIN
   DECLARE
      abc INTEGER RANGE 0..15;      --Non complaint code (Improper constraint is used)
	  xyz NUMBER RANGE 0..25;       --Non complaint code (Improper constraint is used)
   BEGIN
      IF xyz = outerloop.abc THEN  
         NULL;
      END IF;
   END;
END; 
Visual Expert 2020
 VEPLSQLRULE11