I try with QGIS to insert new features in a multi-table Oracle Spatial view that is updatable by adding an "instead of" trigger. The view is "key-preserved" and I don't have any problem when I insert a new feature directly in SQL.
But when I try to do this in QGIS (QGIS 2.18.24 as QGIS 3.2) I get this error :
Oracle error while adding features: Oracle error: Could not retrieve feature id -2 SQL: Error: SELECT "OBJECTID" FROM "MY_SCHEMA"."MY_VIEW" WHERE ROWID=:f
Despite this error, the feature is inserted in my database anyway. The problem is, if I save layer edits another time, my feature would be recorded 2 times.
Is this a limitation of the Oracle Spatial QGIS connector or I can do something to have a workaround solution?