Name
DBMS_DEFER_SYS.EXECUTE_ERROR
Synopsis
The EXECUTE_ERROR procedure executes transactions in the DEFERROR data dictionary view after the cause of the error has been resolved. As with the DELETE_ERROR and DELETE_TRAN procedures, you may pass NULLs to indicate wildcards.
PROCEDURE DBMS_DEFER_SYS.EXECUTE_ERROR
(deferred_tran_id IN VARCHAR2,
deferred_tran_db IN VARCHAR2,
destination IN VARCHAR2);Parameters
Parameter Name | Description |
|---|---|
deferred_tran_id | ID of transaction in the DEFERROR data dictionary view |
deferred_tran_db | Global name of database that originated or copied the transaction originally |
destination | Global name of destination database |
Exceptions
Exception Name | Number | Description |
|---|---|---|
ORA-24275 | –24275 | destination is NULL, or deferred_tran_id and deferred_tran_db are neither both NULL nor both NOT NULL. |
If execution stops because of an exception, the EXECUTE_ERROR procedure raises the last exception encountered.
Restrictions
The destination parameter may not be NULL.
The deferred_tran_id and deferred_tran_db parameters must either both be NULL or both be NOT NULL. If they are NULL, all transactions in DEFERROR destined for destination are applied.