Search code examples
oracleoracle-sqldeveloper

Data got committed in another/same session, cannot update row (Oracle SQL Developer)

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.

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.