Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_DEFER.TRANSACTION

Purpose

To indicate the start of a new deferred transaction. If you omit this call, Oracle considers your first call to DBMS_DEFER.CALL to be the start of a new transaction. For additional information, refer to

Syntax

The parameter for the TRANSACTION procedure is described in Table 12 - 7, and the exceptions are listed in Table 12 - 8. The syntax for this procedure is as follows:

DBMS_DEFER.TRANSACTION

DBMS_DEFER.TRANSACTION(	nodes		IN	node_list_t)

Note: The transaction procedure is overloaded. The behavior of the version without a parameter is similar to that of the version with a parameter, except that the former uses the nodes in the DefDefaultDest view instead of having a nodes parameter.

Parameter Description
nodes A PL/SQL table of fully qualified database names to which you want to propagate the deferred calls of the transaction. The table is indexed starting at position one until a NULL entry is found, or the NO_DATA_FOUND exception is raised. The data in the table is case insensitive.

Table 12 - 7. Parameter for TRANSACTION

Exception Description
ORA-23304 (malformedcall) The previous transaction was not correctly formed or terminated.
ORA-23319 Parameter value is not appropriate.
ORA-23352 Raised by DBMS_DEFER.CALL if the node list contains duplicates.

Table 12 - 8. Exceptions for TRANSACTION

Parameter	Description
`nodes`	A PL/SQL table of fully qualified database names to which you want to propagate the deferred calls of the transaction. The table is indexed starting at position one until a NULL entry is found, or the NO_DATA_FOUND exception is raised. The data in the table is case insensitive.

Exception	Description
ORA-23304 (malformedcall)	The previous transaction was not correctly formed or terminated.
ORA-23319	Parameter value is not appropriate.
ORA-23352	Raised by DBMS_DEFER.CALL if the node list contains duplicates.