Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_DEFER_SYS.DELETE_ERROR

Purpose

To delete a transaction from the DefError view. If there are not other DefTranDest or DefError entries for the transaction, the transaction is deleted from the DefTran and DefCall views as well. For additional information, refer to

Syntax

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

DBMS_DEFER_SYS.DELETE_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 remove from the DefError view. If this parameter is null, all transactions meeting the requirements of the other parameters are removed.
deferred_tran_db The fully qualified database name from the DefError view of the database in which the transaction that you want to remove from the DefError view originated. If this parameter is null, transactions meeting the requirements of the other parameters are removed.
destination The fully qualified database name from the DefError view of the database to which the transaction was originally queued. If this parameter is null, all transactions meeting the requirements of the other parameters are removed from the DefError view.

Table 12 - 18. Parameters for DELETE_ERROR

Exception

Transaction ID and/or node not found.

Parameter	Description
`deferred_tran_id`	The ID number from the DefError view of the deferred transaction that you want to remove from the DefError view. If this parameter is null, all transactions meeting the requirements of the other parameters are removed.
`deferred_tran_db`	The fully qualified database name from the DefError view of the database in which the transaction that you want to remove from the DefError view originated. If this parameter is null, transactions meeting the requirements of the other parameters are removed.
`destination`	The fully qualified database name from the DefError view of the database to which the transaction was originally queued. If this parameter is null, all transactions meeting the requirements of the other parameters are removed from the DefError view.