This content has been marked as final. Show 2 replies
Turns out, the underlying view, V1 ... is the culprit ...
key preserved table
... when we use the OLD syntax (a "plus") instead of the NEW syntax ("outer join") ... everything works as we expect.
So problem is in Database, not in SQL Developer.
In addition to the database ANSI syntax bug noted in the thread you posted over in the other forum, SQL Developer's object viewer will attempt to detect whether a view is updateable and disable the edit icons in the toolbar if it is not. I recall a bug where the view was updateable, but the edit icons got disabled anyway. I believe that specific issue was fixed, but there may be other cases to be found. The behavior you experience may depend on the particular release of SQL Developer you use.
Anyway, if interested, the following bug contains simple test cases for both updateable and non-updateable views:
Bug 8460737 - ORA-22816 INSERTING ROW INTO VIEW WITH INSTEAD OF TRIGGER USING GRID
By the way, that bug pertains specifically to an updateable view, the issue is entirely different from yours, and it is marked as not feasible to fix.
SQL Developer Team
Edited by: Gary Graham on Mar 28, 2013 2:46 PM