Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_DEFER_SYS.EXECUTE_ERROR

Purpose

To re-execute a deferred transaction that did not initially complete successfully. This procedure raises an ORA-24275 error when illegal combinations of NULL and non-NULL parameters are used. For additional information, refer to

Syntax

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

DBMS_DEFER_SYS.EXECUTE_ERROR(	deferred_tran_id	IN	VARCHAR2,
	deferred_tran_db	IN	VARCHAR2,
	destination	IN	VARCHAR2)

Parameter Description
deferred_tran_id The ID number from the DefError view of the deferred transaction that you want to re-execute. If this parameter is null, all transactions queued for DESTINATION that originated from the DEFERRED_TRAN_DB are re-executed.
deferred_tran_db The fully qualified database name from the DefError view of the database in which the transaction that you want to re-execute originated. If both the DEFERRED_TRAN_ID and DEFERRED_TRAN_DB are null, all transactions originating from any site that were queued for the DESTINATION database that were not successfully executed are re-executed.
destination The fully qualified database name from the DefError view of the database to which the transaction was originally queued. This parameter must not be null.

Table 12 - 24. Parameters for EXECUTE_ERROR

Exception

EXECUTE_ERROR raises the last exception that it encountered before execution stopped as a result of the exception.

Parameter	Description
`deferred_tran_id`	The ID number from the DefError view of the deferred transaction that you want to re-execute. If this parameter is null, all transactions queued for DESTINATION that originated from the DEFERRED_TRAN_DB are re-executed.
`deferred_tran_db`	The fully qualified database name from the DefError view of the database in which the transaction that you want to re-execute originated. If both the DEFERRED_TRAN_ID and DEFERRED_TRAN_DB are null, all transactions originating from any site that were queued for the DESTINATION database that were not successfully executed are re-executed.
`destination`	The fully qualified database name from the DefError view of the database to which the transaction was originally queued. This parameter must not be null.