My Oracle Support Banner

DBMS_APPLY_ADM.SET_DML_CONFLICT_HANDLER Generates ORA-26701 (Doc ID 2676703.1)

Last updated on JUNE 05, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 18.3.0.0.0 and later
Information in this document applies to any platform.

Goal

Unable to create a DML_CONFLICT handler 
  DBMS_APPLY_ADM.SET_DML_CONFLICT_HANDLER (
  apply_name => '<APPLY NAME>',
  conflict_handler_name => '<NAME>',
  object => '<NAME>',
  operation_name => 'UPDATE',
  conflict_type => 'ROW_MISSING',
  method_name => 'OVERWRITE',
  column_table => cols,
  resolution_column => '<COLUMN NAME>'
  );
  END;
/


ERROR at line 1:
ORA-26701: XStream process <APPLY NAME> does not exist
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 2448
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 581
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 635
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 2199
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 1920
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 1876
ORA-06512: at line 2


 The errored apply name exist and is enabled in the output when run below query

sql>select apply_name, status from dba_apply;

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.