5.7. 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 Chapter 20 for details.
5.7.1. 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.
5.7.2. 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.
5.7.3. 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.
5.7.4. 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 ...
Get Advanced Oracle PL/SQL Programming with Packages now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.