Home

SYNCHRONIZE should not be used

Rule description

  • SYNCHRONIZE should not be used

 

Non-compliant Code Example

PROCEDURE UpdateCustomeCity(customerId in integer, city in nvarchar2(200))
IS
BEGIN
UPDATE CUSTOMERS
		SET City=city
		WHERE Id = customerId;
  
	SYNCHRONIZE;        --Non compliant code (SYNCHRONIZE is used)
	
END UpdateCustomeCity;
Visual Expert 2020
 VEPLSQLRULE133