Advanced Oracle PL/SQL Programming with Packages

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