inconsistent behavior with join based views
Hi we are facing what we consider an inconsistent behavior on how Oracle DB (any version tested from 11.2 to 19.3) handles insert in join based views (we know it is not a very good practice but we cannot change some of the DB structure).
We have summarized the problem in a very simple example: We have a join based view with a column that is based on a function. In order to enable inserts through the view, we have created a INSTEAD OF triggers and it works OK.
However, when this view participates in other join view, Oracle rejects inserts through this join view even if this view only select attributes from the view with the instead of trigger.