Lemur zaprasza
[Chapter 5] 5.23 PLVrb: Rollback Processing Chapter 5PL/Vision Package Specifications 5.23 PLVrb: Rollback ProcessingThe 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 Parsing5.24 PLVstk: Stack Manager O'Reilly & Associates. All rights reserved. |