Oracle Error ORA-38106: MERGE not supported on join view or view with INSTEAD OF trigger.

Oracle Error Message

ORA-38106: MERGE not supported on join view or view with INSTEAD OF trigger.

Reason for the Error

The MERGE operation contained a join view or view with INSTEAD of trigger which is not supported.

Solution

When using MERGE to modify a view, you must only specify a single table in the view, and the view cannot have an INSTEAD OF trigger.