Replication Management API Reference, 23 of 179

EXECUTE_ERROR_AS_USER procedure

This procedure re-executes a deferred transaction that did not initially complete successfully. Each transaction is executed in the security context of the connected user.

Syntax

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

Parameters

Table 8-35 EXECUTE_ERROR_AS_USER 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`.

Exceptions

Table 8-36 EXECUTE_ERROR_AS_USER 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.