Advanced Oracle PL/SQL Programming with Packages

Advanced Oracle PL/SQL Programming with PackagesSearch this book
Previous: 5.6 PLVchr: Operations on Single CharactersChapter 5
PL/Vision Package Specifications
Next: 5.8 PLVddd: DDL Syntax Dump
 

5.7 PLVcmt: Commit Processing

The PLVcmt (PL/Vision CoMmiT) package provides a programmatic interface to the execution of commits, rollbacks, and the setting of savepoints. See Chapter 20, PLVcmt and PLVrb: Commit and Rollback Processing for details.

5.7.1 Controlling commit activity

PROCEDURE turn_on;

Enables commit processing in PLVcmt. This is the default.

PROCEDURE turn_off;

Disables commit processing in PLVcmt. When this program is called in the current session, the COMMIT statement will not be executed.

FUNCTION committing RETURN BOOLEAN;

Returns TRUE if commit processing is being performed by PLVcmt.

5.7.2 Logging commit activity

PROCEDURE log;

Requests that, whenever a COMMIT is performed, a message be sent to the PL/Vision log.

PROCEDURE nolog;

Do not log a message with the COMMIT.

FUNCTION logging RETURN BOOLEAN;

Returns TRUE if currently logging the fact that a commit was performed by PLVcmt.

5.7.3 Performing commits

PROCEDURE increment_and_commit (context_in IN VARCHAR2 := NULL);

Increments the counter and commits if a commit point has been reached.

PROCEDURE perform_commit(context_in IN VARCHAR := NULL);

The PLVcmt package's version of COMMIT. I could probably get away with calling this program commit, but I avoid using keywords even when the compiler doesn't seem to get confused.

5.7.4 Managing the commit counter

PROCEDURE commit_after (count_in IN INTEGER);

Sets the break point at which a commit is performed. In other words, when the package-based counter reaches the specified number, issue a COMMIT. The default is to commit after the counter reaches 1.

PROCEDURE init_counter;

Initializes the PLVcmt counter referenced by the increment_and_commit program to perform incremental commits.


Previous: 5.6 PLVchr: Operations on Single CharactersAdvanced Oracle PL/SQL Programming with PackagesNext: 5.8 PLVddd: DDL Syntax Dump
5.6 PLVchr: Operations on Single CharactersBook Index5.8 PLVddd: DDL Syntax Dump

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