Cannot commit change in SQL developer

Question

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?

Did you try refreshing the result set before making the edit? — Jeffrey Kemp
– Jeffrey Kemp, Commented Mar 19, 2015 at 7:40
What was shown after "One error saving changes to table "EVO"."T_CAP_SUM":"? — Jeffrey Kemp
– Jeffrey Kemp, Commented Mar 19, 2015 at 7:53

Roland Kwee · Accepted Answer · 2017-11-10 16:27:16Z

3

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).

edited Nov 10, 2017 at 16:27

Roland Kwee

5,3027 gold badges59 silver badges91 bronze badges

answered Mar 19, 2015 at 5:01

Sagar Joon

1,41715 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Monkawee Maneewalaya Over a year ago

Sorry. I not found your option.

Jeffrey Kemp Over a year ago

@Monkawee, what version of SQL Developer are you using? The ORA_ROWSCN option is under Tools -> Preferences, Database -> ObjectViewer. Might be worth trying.

Monkawee Maneewalaya Over a year ago

@jeffrey, Version 1.5.5. but, under Database option is ObjectViewer Parameter. Are you mean that? If that true. The ORA_ROWSCN not exists.

Jeffrey Kemp Over a year ago

Perhaps you need to upgrade to a supported version - it's now up to version 4.0...

Monkawee Maneewalaya Over a year ago

@JeffreyKemp, I not need to upgrade now. However, I would like to accept your answer. Thank you.

|

Ankur Bhutani · Accepted Answer · 2016-06-08 06:47:33Z

1

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

answered Jun 8, 2016 at 6:47

Ankur Bhutani

3,2794 gold badges34 silver badges27 bronze badges

Collectives™ on Stack Overflow

Cannot commit change in SQL developer

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related