SQL Developer

Error: Data got committed in another/same session, cannot update row. sqldeveloper 1.5.1 build 5440 against 10g server.

I am using sqldeveloper's worksheet to do minor cleanups on a database table - simple editing of a mis-spelling in a column. Out of 120 rows, 108 could be edited without problem, but 12 keep giving me the error shown above when I try to commit. I only have the one session open and there is only one other user active and he is programatically restricted to editing one record at a time. So there is no way 12 records should be locked out from update or could have been updated by another. Refreshing the worksheet before editing doesn't help.

So, what does this error mean and how do I work around it???

I have a lot more little cleanups to do in this table and would appreciate a solution to the problem.

The table has a clob field - I had encountered the same error earlier when trying to delete a record with a blob field - the only solution there was to set the blob to null and then delete the record. There is no way I can fool around with the clob in the current table.

Would appreciate any help you can give....

glenn