How to fix the Oracle error ORA-26880: “SET_EXECUTE” directive is not permitted on rules used by XStream outbound server “string”?

In this post, you’ll learn more about the Oracle ErrorORA-26880: “SET_EXECUTE” directive is not permitted on rules used by XStream outbound server “string” with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error ORA-26880: “SET_EXECUTE” directive is not permitted on rules used by XStream outbound server “string” ?

You can fix this error in Oracle by following the below steps

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.