Skip to Main Content
Advanced Oracle PL/SQL Programming with Packages
book

Advanced Oracle PL/SQL Programming with Packages

by Steven Feuerstein
October 1996
Intermediate to advanced content levelIntermediate to advanced
687 pages
16h 41m
English
O'Reilly Media, Inc.
Content preview from Advanced Oracle PL/SQL Programming with Packages

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 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

Michael McLaughlin
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Expert Oracle PL/SQL

Expert Oracle PL/SQL

Ron Hardman, Michael McLaughlin

Publisher Resources

ISBN: 1565922387Supplemental ContentCatalog PageErrata