Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_DEFER_SYS.DELETE_TRAN

Purpose

To delete a transaction from the DefTranDest 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_TRAN procedure are described in Table 12 - 19. The syntax for this procedure is shown below:

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

Parameter Description
deferred_tran_id The ID number from the DefTran view of the deferred transaction that you want to delete. If this parameter is null, all transactions meeting the requirements of the other parameters are deleted.
deferred_tran_db The fully qualified database name from the DefTran view of the database in which the transaction that you want to delete originated. If this parameter is null, transactions meeting the requirements of the other parameters are deleted.
destination The fully qualified database name from the DefTranDest 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 deleted.

Table 12 - 19. Parameters for DELETE_TRAN

Exception

Transaction ID and/or node not found.

Parameter	Description
`deferred_tran_id`	The ID number from the DefTran view of the deferred transaction that you want to delete. If this parameter is null, all transactions meeting the requirements of the other parameters are deleted.
`deferred_tran_db`	The fully qualified database name from the DefTran view of the database in which the transaction that you want to delete originated. If this parameter is null, transactions meeting the requirements of the other parameters are deleted.
`destination`	The fully qualified database name from the DefTranDest 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 deleted.