delete_error Procedure

The delete_error procedure deletes the specified error transaction. When the error transaction as been resolved by other means, the DBA may not be interested in using the error transaction. In this case, the error transaction can be dropped from the error queue.  The following SQL block shows the usage of the delete_error proedure:

Syntax:
EXEC DBMS_APPLY_ADM.DELETE_ERROR( local_transaction_id IN VARCHAR2);

local_transaction_id is the identification number of the error transaction to delete.

delete_all_errors Procedure

The delete_all_errors procedure deletes all the error transactions for a given Apply process. When the error condition has been resolved by other means, the errors will have to be cleared from the queue. When there are a large number of error transactions to delete, this procedure will be useful. For example, the following SQL drops all the error transactions from the LN4_APPLY Apply process: