Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_DEFER_SYS.COPY

Purpose

To create a copy of a deferred transaction with a new destination. For additional information, refer to

Syntax

The parameters for the COPY procedure are described in Table 12 - 16. The syntax for this procedure is shown below:

DBMS_DEFER_SYS.COPY
 (deferred_tran_id	IN	VARCHAR2,
 deferred_tran_db	IN	VARCHAR2,
 destination_list	IN	dbms_defer.node_list_t,
 destination_count	IN	BINARY_INTEGER)

Parameter Description
deferred_tran_id The ID number from the DefTran view of the deferred transaction that you want to copy.
deferred_tran_db The fully qualified database name from the DefTran view of the database in which the transaction that you want to copy originated.
destination_list A PL/SQL table of fully qualified database names to which you want to propagate the deferred calls of the copied transaction. The table is indexed starting at position one and the data in the table is case insensitive.
destination_count The number of entries in the DESTINATION_LIST table.

Table 12 - 16. Parameters for COPY

Parameter	Description
`deferred_tran_id`	The ID number from the DefTran view of the deferred transaction that you want to copy.
`deferred_tran_db`	The fully qualified database name from the DefTran view of the database in which the transaction that you want to copy originated.
`destination_list`	A PL/SQL table of fully qualified database names to which you want to propagate the deferred calls of the copied transaction. The table is indexed starting at position one and the data in the table is case insensitive.
`destination_count`	The number of entries in the DESTINATION_LIST table.