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
Visual Expert 2020
 VEPLSQLRULE139