Database Software

Good morning,

I'm posting here today to get some advice on handling ORA-01403 on DELETE statements. The issue is that the source row values do not match the destination row values, and ultimately the best scenario would be to sync up there rows between the two sites to avoid the errors all together. However, I would like to have a handler in place to address these errors. I deally I would like to process the DELETE transaction regardless row value differences.

Just to help explain this is the scenarion:
Site 1
Table_A
Col_PK vale: 1
Col2 value: 'Test'

Site 2
Table _A
Col_PK vale: 1
Col2 value: 'Test 1'

now this delete statement is issued on Site 1
DELETE FROM TABLE_A WHERE col_pk=1;

This statement will fail oin Site 2 since col2 values are different with an ORA-01403.

What I want to happen on Site 2 is for the DELETE to be processed. I know I'll need to write a DML Error handler to address this, but I wanted to get your thoughts on what the best process or method is.

Thank you for your help!