Home
FORALL should be used
Rule description
- FORALL should be used
Non-compliant Code Example
BEGIN
managerId := Employees.GetManagerByEmployee(:old.EMP_ID);
for c in c1 loop --Non compliant code (FORALL should be used)
UPDATE PRODUCT
SET MANAGER_ID = managerId
WHERE c.ID = Id;
end loop;
END;
Compliant Code Example
BEGIN
managerId := Employees.GetManagerByEmployee(:old.EMP_ID);
forall i IN 1..c1 --Compliant code (FORALL is used)
UPDATE PRODUCT
SET MANAGER_ID = managerId
WHERE iterator(i).ID = Id;
END;