Home
FORALL statements should use the SAVE EXCEPTIONS clause
Rule description
- FORALL statements should use the SAVE EXCEPTIONS clause
Non-compliant Code Example
BEGIN
FORALL j IN CUSTOMER_TABLE.FIRST..CUSTOMER_TABLE.LAST --Non compliant code (FORALL statements does not used SAVE EXCEPTIONS clause)
UPDATE CUSTOMERS SET minimunExpense = 1800
WHERE 100 < CUSTOMER_TABLE(j);
EXCEPTION
WHEN OTHERS THEN
error_message := SQLERRORMSG;
DBMS_OUTPUT.PUT_LINE (error_message);
COMMIT;
RAISE;
END;
Compliant Code Example
BEGIN
FORALL j IN CUSTOMER_TABLE.FIRST..CUSTOMER_TABLE.LAST SAVE EXCEPTIONS --Compliant code (FORALL statements used SAVE EXCEPTIONS clause)
UPDATE CUSTOMERS SET minimunExpense = 1800
WHERE 100 < CUSTOMER_TABLE(j);
EXCEPTION
WHEN OTHERS THEN
error_message := SQLERRORMSG;
DBMS_OUTPUT.PUT_LINE (error_message);
COMMIT;
RAISE;
END;