-907 AN ATTEMPT WAS MADE TO MODIFY THE TARGET TABLE, table-name, OF THE MERGE STATEMENT BY CONSTRAINT OR TRIGGER trigger-name.
Explanation
The MERGE statement caused a constraint or trigger to activate. The trigger attempted to update, insert into or delete from the target table or a table within the same table hierarchy of the MERGE statement. This is not allowed.
- table-name
- The name of the target table of the MERGE statement.
- trigger-name
- The name of the trigger that attempted to modify the target table.
System action
The statement cannot be processed.
Programmer response
Change the MERGE statement to remove the operation that causes the constraint or trigger to activate, or alter the table that has the constraint or trigger to remove the reference to the target table.
SQLSTATE
27000