SQL Language (MOSC)

MOSC Banner

inconsistent behavior with join based views

edited May 20, 2020 5:01AM in SQL Language (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center