Advanced Oracle PL/SQL Programming with Packages

Advanced Oracle PL/SQL Programming with PackagesSearch this book
Previous: 5.22 PLVprsps: PL/SQL Source Code ParsingChapter 5
PL/Vision Package Specifications
Next: 5.24 PLVstk: Stack Manager
 

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.


Previous: 5.22 PLVprsps: PL/SQL Source Code ParsingAdvanced Oracle PL/SQL Programming with PackagesNext: 5.24 PLVstk: Stack Manager
5.22 PLVprsps: PL/SQL Source Code ParsingBook Index5.24 PLVstk: Stack Manager

The Oracle Library Navigation

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference
This HTML Help has been published using the chm2web software.