EXECUTE_ERROR Procedure

This procedure reexecutes 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 14-14 EXECUTE_ERROR Procedure Parameters

Parameter	Description
deferred_tran_id	Identification number from the `DEFERROR` view of the deferred transaction that you want to reexecute. If this is `NULL`, then all transactions queued for `destination` are reexecuted.
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 14-15 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.