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 ...
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.