5.23 PLVrb: Rollback Processing
The PLVrb (PL/Vision RollBack) package provides a programmatic interface to rollback activity in PL/SQL . See Chapter 20 for details.
5.23.1 Controlling rollback activity
-
PROCEDURE turn_on; -
Enables rollback processing in PLVrbPLVcmt. This is not the default.
-
PROCEDURE turn_off; -
Disables rollback processing in PLVrbPLVcmt. When this is called in the current session, the ROLLBACK statement will not be executed (the default).
-
FUNCTION rolling_back RETURN BOOLEAN; -
Returns TRUE if rollback processing is being performed by PLVrbPLVcmt.
5.23.2 Logging rollback activity
-
PROCEDURE log; -
Requests that whenever a ROLLBACK is performed, a message is sent to the PL/Vision log.
-
PROCEDURE nolog; -
Do not log a message with the ROLLBACK.
-
FUNCTION logging RETURN BOOLEAN; -
Returns TRUE if currently logging the fact that a rollback was performed by PLVrbPLVcmt.
5.23.3 Performing rollbacks
-
PROCEDURE perform_rollback (context_in IN VARCHAR2 := NULL); -
Issues a ROLLBACK command.
-
PROCEDURE rollback_to -
(sp_in IN VARCHAR2, context_in IN VARCHAR2 := NULL); -
Issues a ROLLBACK to the specified savepoint.
-
PROCEDURE rb_to_last (context_in IN VARCHAR2 := NULL); -
Issues a ROLLBACK to the last savepoint specified in a call to set_savepoint .
5.23.4 Managing savepoints
-
PROCEDURE set_savepoint (sp_in IN VARCHAR2); -
Sets a savepoint by soft-coded string, rather than the usual hard-coded savepoint identifier. This savepoint is set to the "last savepoint" recorded by PLVrbPLVcmt.
-
FUNCTION lastsp RETURN VARCHAR2; -
Returns the name of the last savepoint.
-
PROCEDURE reset_savepoints; -
Clears the stack of savepoints maintained by PLVrb. This is called by PLVrbPLVcmt after a commit is performed.
|
|
|
| 5.22 PLVprsps: PL/SQL Source Code Parsing |
|
5.24 PLVstk: Stack Manager |
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.