Menu
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.
420
The thing that does work is using Alt-F10 to open a new worksheet, choosing a connection, waiting for the new worksheet to open then go back to the original worksheet that was already open and executing my query. After doing all of this, the query will normally run.
If you are running a script, instead of a statement, you can increase this by selecting Tools/Preferences/Worksheet and increasing "Max Rows to print in a script". The default is 5000, you can change it to any size. Save this answer. Show activity on this post.
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.
107
Just simply run simple update command and set your cplumn to null. Then try to update with your real value. It will definitely work.
25
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
