CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloperoracle11gr2
Monkawee Maneewalaya
Monkawee Maneewalaya

Reputation: 150

Cannot commit change in SQL developer

I changed data in table field and then I clicked on the "COMMIT" icon. The data was not updated and I saw this message from the Data Editor-log.

One error saving changes to table "EVO"."T_CAP_SUM":

However, when I used a query, the data has been updated.

UPDATE T_CAP_SUM SET FCNT_004 = '0' WHERE CELL_NO = 'MAT-02'

Why does this happen?

Upvotes: 0

Views: 12856

Answers (2)

Sagar Joon
Sagar Joon

Reputation: 1417

In some cases SQL Developer's method of updating with a predicate on ROW_SCN doesn't work. In these cases you can often workaround the problem by unchecking the "Use ORA_ROWSCN" option, via Tools -> Preferences, Database -> ObjectViewer. This option is available in recent versions of SQL Developer (including 4.0).

Upvotes: 3

Ankur Bhutani
Ankur Bhutani

Reputation: 3219

Not sure if your row is having date type column or not. If yes then check whether date is in correct format or not. As incorrect date format can also result in above mentioned error

Upvotes: 1

Related Questions