#

| Chapter 5 PL/Vision Package Specifications |

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