April 1999
Intermediate to advanced
552 pages
15h 39m
English
Content preview from Oracle Distributed Systems
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,
Start your free trial
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