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.