Oracle Error ORA-26880: “SET_EXECUTE” directive is not permitted on rules used by XStream outbound server “string”

Oracle Error Message

ORA-26880: “SET_EXECUTE” directive is not permitted on rules used by XStream outbound server “string”

Reason for the Error

One or more rules, used by the specified XStream outbound server, had SET_EXECUTE directive defined.

Solution

Execute the following: 1) Execute query SELECT xr.rule_owner, xr.rule_name, xr.rule_set_owner, xr.rule_set_name FROM dba_apply_execute e, dba_xstream_rules xr WHERE e.rule_owner = xr.rule_owner AND e.rule_name = xr.rule_name AND xr.streams_name = ; 2) For each rule returned, use DBMS_APPLY_ADM.SET_EXECUTE procedure to set the EXECUTE parameter to TRUE, or use DBMS_RULE_ADM.REMOVE_RULE to remove that rule from its associated rule set.