Data got committed in another/same session, cannot update row (Oracle SQL Developer)
oracle, oracle-sqldeveloper
Solution
It could be that your table is created with NOROWDEPENDENCIES so row-level dependency tracking is turned off, and SQL Developer is configured to "Use ORA_ROWSCN for DataEditor insert and update statements".
Either uncheck the ORA_ROWSCN option, or recreate the table with ROWDEPENDENCIES.
Problem
I occasionally get this error when i try to update a record through the grid. ``` One error saving changes to table "SCHEMA"."TABLENAME": Row 3: Data got committed in another/same session, cannot update row. ``` Looked up at OTN but no solution yet given. Tried to disable the option Post edits on row change but still no luck. There is a known solution for setting the field to NULL through the SQL Worksheet but it's surely a pain.