Foreign Key Violations , Logging Errors


Foreign Key Violations , Logging Errors

Hi ,

If we specify insert/select with logging error clause , during the insert if it encounter any foreign key violations , it will insert the error record in error table.

1) Child table has multiple RI say a.col1 references parent_tab(col1) , a.col2 references parent_tab(col2) .
2) Record may fail due to RI violations on a.col1 or could be due RI Violations on a.col2.
3) Record in error table will not show us the column/RI Constraint name (either a or b) which cause the error.

Is there any other way to get the error record plus RI Constraint name for those record violations.