update query with dml error logging does not work in case of referencial integrity on the same table
Hello Experts,
We have an update sql statement on a table that has an error table corresponding to it. The update statement has clause "log error reject unlimited" which works fine for null constraint. But in case of foreign key constraints which refer to some other column of the same table it does not work and throws "ORA-02291: integrity constraint (USER.LOCATION_PARENT_LOC_FK) violated - parent key not found" . Please note that the constraint LOCATION_PARENT_LOC_FK refers to some other column of the SAME table. When we have similar foreign key constraint that refer to other table column, then dml error logging properly works