PLVrb: Rollback Processing

The PLVrb (PL/Vision RollBack) package provides a programmatic interface to rollback activity in PL/SQL. See for details.

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.

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.

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.