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.
Leave a Review