Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[4.0] Bug - can't save changes in table after clearing date field with shift+delete

ArpodDec 26 2013 — edited May 6 2014

Steps to reproduce:

1) Open any table containing columns of DATE type, go to "Data" tab

2) Find any non-null cell in said column

3) Select said cell, press shift+delete. Cell's value becomes (null) and row is marked for update.

4) Press Commit button or F11

After that, this line appears in "Messages" window:

One error saving changes to table "SCHEMA"."TABLE_NAME":

If you clear column by typing space and deleting it, cell's value becomes (null) as well, but commit works. Update statement from worksheet also work, so it's not a table issue.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2014
Added on Dec 26 2013
5 comments
2,503 views