I'm using the Oracle SQL Developer application.

Version 2.1.0.63
Build MAIN-63.73

Via the application's grid view I am trying to paste a value into a field for a single record. Field type: VARCHAR2(4000 CHAR), although I've heard this problem can also happen with CLOB/BLOB type fields.

I paste, then hit the "commit" button at the top of the grid interface. Immediately I get the following error:

"Data got committed in another/same session, cannot update row."

I say, "huh?!" ... then proceed to try it again a few times mindlessly ignoring the fact that obviously something is wrong.

Google ended up being my saviour once again when I found: http://goo.gl/2vOL in the Oracle Forums.

The following is the solution that I gleaned from the forum link above (originally posted by 'gconley'):

1. Copy and edit the value to a safe place such as notepad or another sql developer worksheet, don't try to save in the table.
2. In a sql developer worksheet, make an update query to set the BLOB/CLOB field to NULL
3. Run the update query and commit
4. Refresh your table view, the BLOB/CLOB should be NULL now
5. Copy the value back in and commit