The PLVcmt (PL/Vision CoMmiT) package provides a programmatic interface to the execution of commits, rollbacks, and the setting of savepoints. See Chapter 20, PLVcmt and PLVrb: Commit and Rollback Processing for details.
Enables commit processing in PLVcmt. This is the default.
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.
Requests that, whenever a COMMIT is performed, a message be sent to the PL/Vision log.
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.
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.
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.
Initializes the PLVcmt counter referenced by the increment_and_commit program to perform incremental commits.
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.