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, PLVcmt and PLVrb: Commit and Rollback Processing 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 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.
|
|
|
| 5.6 PLVchr: Operations on Single Characters |
|
5.8 PLVddd: DDL Syntax Dump |
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.