Home
FORMS_DDL('COMMIT') and FORMS_DDL('ROLLBACK') should not be used
Rule description
- FORMS_DDL('COMMIT') and FORMS_DDL('ROLLBACK') should not be used
Non-compliant Code Example
BEGIN IF Form_Success then FORMS_DDL('COMMIT'); --Non compliant code (FORMS_DDL('COMMIT') is used) ELSIF NOT Form_Success then FORMS_DDL('ROLLBACK'); --Non compliant code (FORMS_DDL('ROLLBACK') is used) END IF; END
Compliant Code Example
BEGIN IF Form_Success then COMMIT_FORM; --Compliant code ELSIF NOT Form_Success then ROLLBACK; --Compliant code END IF; END