Need help! SQLD error: Data got commited in another/same session.
672869Mar 4 2009 — edited Feb 23 2011We started to have this error about 2 months ago in SQL Developer. When we tried to update multiple rows at once. The error messages are shown like this:
===============================================
UPDATE "FXTNT"."FX_XREF_1" SET XREF_CAN_VALUE = 'inp0010000000ipvendr~mcmaste006931349P' WHERE ROWID = 'AAAIrvAA5AAAFzyAAa' AND ORA_ROWSCN = '4147142517'
UPDATE "FXTNT"."FX_XREF_1" SET XREF_CAN_VALUE = 'inp0010000000ipvendr~mcmaste006931349P' WHERE ROWID = 'AAAIrvAA5AAAFzbAAE' AND ORA_ROWSCN = '4147142517'
3 errors saving changes to table "FXTNT"."FX_XREF_1":
Row 11: Data got commited in another/same session, cannot update row.
Row 16: Data got commited in another/same session, cannot update row.
Row 17: Data got commited in another/same session, cannot update row.
===============================================
We are not sure what change make this happens to the SQL developer. I saw that we have some threads posted earlier here. But do not see any effective answer/solution yet. I will be greatly appreciated if anybody can provide any help on this.
Thanks!