PLVcmt: Commit Processing

The PLVcmt (PL/Vision CoMmiT) package provides a programmatic interface to the execution of commits, rollbacks, and the setting of savepoints. See PLVcmt and PLVrb: Commit and Rollback Processing for details.

Controlling commit activity

• PROCEDURE turn_on;
• Enables commit processing in PLVcmt. This is the default.
• PROCEDURE turn_off;
• Disables commit processing in PLVcmt. When this program is called in the current session, the COMMIT statement will not be executed.
• FUNCTION committing RETURN BOOLEAN;
• Returns TRUE if commit processing is being performed by PLVcmt.

Logging commit activity

• PROCEDURE log;
• Requests that, whenever a COMMIT is performed, a message be sent to the PL/Vision log.
• PROCEDURE nolog;
• Do not log a message with the COMMIT.
• FUNCTION logging RETURN BOOLEAN;
• Returns TRUE if currently logging the fact that a commit was performed by PLVcmt.

Performing commits

• PROCEDURE increment_and_commit (context_in IN VARCHAR2 := NULL);
• Increments the counter and commits if a commit point has been reached.
• PROCEDURE perform_commit(context_in IN VARCHAR := NULL);
• The PLVcmt package's version of COMMIT. I could probably get away with calling this program commit, but I avoid using keywords even when the compiler doesn't seem to get confused.

Managing the commit counter

• PROCEDURE commit_after (count_in IN INTEGER);
• Sets the break point at which a commit is performed. In other words, when the package-based counter reaches the specified number, issue a COMMIT. The default is to commit after the counter reaches 1.
• PROCEDURE init_counter;
• Initializes the PLVcmt counter referenced by the increment_and_commit program to perform incremental commits.