Name

DBMS_DEFER_SYS.DELETE_ERROR

Synopsis

The DELETE_ERROR procedure allows you to delete transactions from the DEFERROR data dictionary view. The procedure also deletes the related entries from DEFCALL, DEFTRAN, and DEFTRANDEST. Use DELETE_ERROR if you have manually resolved a transaction that initially failed.

PROCEDURE DBMS_DEFER_SYS.DELETE_ERROR
   (deferred_tran_id IN VARCHAR2,
    deferred_tran_db IN VARCHAR2,
    destination      IN VARCHAR2);

There are no restrictions on calling DELETE_ERROR.

Parameters

Parameter Name

Description

deferred_tran_id

ID from the DEFTRAN data dictionary view of the transaction to be deleted from DEFERROR. If NULL, all entries for the specified deferred_tran_db and destination are deleted.

deferred_tran_db

Global name of the originating database. If NULL, all entries for the specified deferred_tran_id and destination are deleted.

destination

Global name of the destination database. If NULL, all entries for the specified deferred_tran_id and deferred_tran_db are deleted.

Exceptions

Exception Name

Number

Description

NO_DATA_FOUND

–01403

Specified deferred_tran_id does not exist, specified deferred_tran_db does not exist, or specified destination does not exist.

Get Oracle Distributed Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial