execute_all_errors Procedure

Syntax:
DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS(
apply_name                  IN VARCHAR2 DEFAULT NULL,
execute_as_user           IN BOOLEAN DEFAULT false);

When the execute_as_user parameter is set to TRUE, the transactions are executed in the security context of the current user.

The procedure presented in the next section is almost the same as the one presented above, but it acts on a specific error transaction.

execute_error Procedure

The execute_error procedure re-executes the specified error transaction.

Syntax:
DBMS_APPLY_ADM.EXECUTE_ERROR(
 local_transaction_id      IN VARCHAR2,
 execute_as_user                       IN BOOLEAN DEFAULT false);

The local_transaction_id is the identification number of the error transaction to execute. If the specified transaction does not exist in the error queue, an error is raised. When the parameter execute_as_user is set to TRUE, the procedure re-executes the transaction in the security context of the current user.