Name

DBMS_DEFER.COMMIT_WORK

Synopsis

The COMMIT_WORK procedure issues a COMMIT command to commit the transaction constructed by the preceding TRANSACTION and CALL procedures.

PROCEDURE DBMS_DEFER.COMMIT_WORK
   (commit_work_comment IN VARCHAR2);

commit_work_comment is a description of the transaction. The comment may be up to 50 characters.

Exceptions

Exception Name

Number

Description

malformedcall

–23304

Number of arguments in the CALL procedure does not match value arg_count, there are missing calls to the datatype_ARG procedure, or the TRANSACTION procedure was not called for this transaction.

Restrictions

If the destination nodes are not specified in DBMS_REPCAT, they are determined by one of the following, in order of procedure:

  • List of nodes in parameter passed to CALL

  • List of nodes in parameter passed to TRANSACTION

  • Entries in DEFTRANDEST

Get Oracle Distributed Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.