Advanced Oracle Pl/Sql: Programming With Packages (Nutshell Handbook)
ISBN: B00006AVR6
EAN: N/A
EAN: N/A
Year: 1995
Pages: 195
Pages: 195
Authors: Steven Feuerstein, Debby Russell
| Chapter 5 PL/Vision Package Specifications |
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.
| 5.22 PLVprsps: PL/SQL Source Code Parsing | 5.24 PLVstk: Stack Manager |
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.