SQL Language (MOSC)

MOSC Banner

update query with dml error logging does not work in case of referencial integrity on the same table

edited Oct 3, 2014 5:02AM in SQL Language (MOSC) 1 commentAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center