The PLVrb (PL/Vision RollBack) package provides a programmatic interface to rollback activity in PL/SQL. See Chapter 20 for details.
Enables rollback processing in PLVrbPLVcmt. This is not the default.
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.
Requests that whenever a ROLLBACK is performed, a message is sent to the PL/Vision log.
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.
(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.
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.