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

oracle oracle-sqldeveloper
MaVRoSCy picture MaVRoSCy · May 22, 2012 · Viewed 27.8k times · Source

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.

Answer

David Aldridge picture David Aldridge · May 22, 2012

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.

Related questions

How to export query result to csv in Oracle SQL Developer?

I'm using Oracle SQL Developer 3.0. Trying to figure out how to export a query result to a text file (preferably CSV). Right clicking on the query results window doesn't give me any export options.

Read More
Changing password with Oracle SQL Developer

Many of my users do not use SQLPlus. I cannot give them alter user. We expire passwords every 60 days. I can't get the SQLPlus command "password" to work in SQL developer. When I hit run, I get an invalid command …

Read More
How to generate an entity-relationship (ER) diagram using Oracle SQL Developer

I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new to Oracle and this tool. What is the process for creating an ER diagram in SQL Developer?

Read More