The PLVrb (PL/Vision RollBack) package provides a programmatic interface to rollback activity in PL/SQL. See Chapter 20 for details.
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.
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.
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.
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.
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.