Oracle Error ORA-38914: Either mutate the error or ignore row on unique violation

Oracle Error Message

ORA-38914: Either mutate the error or ignore row on unique violation

Reason for the Error

IGNORE_ROW_ON_DUPKEY_INDEX and CHANGE_DUPKEY_ERROR_INDEX were both specified in the same statement.

Solution

You cannot specify both hints in the same statement. Remove one of these two hints, or both, from the statement.