Replication Management API Reference, 22 of 179

EXECUTE_ERROR procedure

This procedure re-executes a deferred transaction that did not initially complete successfully in the security context of the original receiver of the transaction.

Syntax

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

Parameters

Table 8-33 EXECUTE_ERROR Procedure Parameters

Parameter	Description
deferred_tran_id	ID number from the `DEFERROR` view of the deferred transaction that you want to re-execute. If this is `NULL`, then all transactions queued for `destination` are re-executed.
destination	The fully qualified database name from the `DEFERROR` view of the database to which the transaction was originally queued. This must not be `NULL`. If the provided database name is not fully qualified or is invalid, no error will be raised.

Exceptions

Table 8-34 EXECUTE_ERROR Procedure Exceptions

Exception	Description
ORA-24275 error	Illegal combinations of `NULL` and non-`NULL` parameters were used.
badparam	Parameter value missing or invalid (for example, if `destination` is `NULL`).
missinguser	Invalid user.