Hello,
Could somebody please help me with following problem?
I want the "replicat" to IGNORE/DISCARD ORA-01403 error, for this I added REPERROR at the end of the MAP as in the following line:
MAP T_REPORT, TARGET T_REPORT REPERROR(1403,DISCARD);
The problem is that it ignore/discard ORA-01403 (No data found) for all operations (DELETE and UPDATE) but I want it do be valid only for DELETE. So I need something like this
MAP T_REPORT, TARGET T_REPORT REPERROR(1403,DISCARD, 'ON DELETE');
but ofcourse REPERROR does't work like this, does anybody has an idea how to achieve this result? (to ignore "data not found" only for DELETE operation)
(OracleDB verion 12, GG version 12.3..)
THANKS!!!!