Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_DEFER.COMMIT_WORK

Purpose

To perform a transaction commit after checking for well formed deferred remote procedure calls.

Syntax

The parameter for the COMMIT_WORK procedure is described in Table 12 - 3, and the exception is listed in Table 12 - 4. The syntax for this procedure is as follows:

DBMS_DEFER.COMMIT_WORK(commit_work_comment IN VARCHAR2)

Parameter Description
commit_work_ comment Up to 50 bytes to describe the transaction in the DEF$_CALL table.

Table 12 - 3. Parameter for COMMIT_WORK

Exception Description
ORA-23304 (malformedcall) The transaction was not correctly formed or terminated.

Table 12 - 4. Exception for COMMIT_WORK

Parameter	Description
`commit_work_ comment`	Up to 50 bytes to describe the transaction in the DEF$_CALL table.

Exception	Description
ORA-23304 (malformedcall)	The transaction was not correctly formed or terminated.