org.sonar.l10n.plsqlopen.rules.plsql.CommitRollback.html Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of zpa-checks Show documentation

Z PL/SQL Analyzer :: Checks

The newest version!


Usually, the control of the transaction should be handled by the its "owner".
If the transaction was started by some Java code, the commit and rollback of this should be done in the Java code.



So, in this situation, calling a COMMIT or ROLLBACK from a database object is a bad pratice and should be avoided. 



This rule ignores procedures and functions with PRAGMA AUTONOMOUS_TRANSACTION.