Not updating a CLOB field?

M Myers

Member
I'm using PL/SQL developer version 6.0.1.848 against an Oracle database version 10.2.0.3.0. There is a CLOB field that I'm trying to update but it just won't take. Here are my steps:
1) I've selected the record 'for update'
2) Then I select the 'Edit Data' icon
3) Press the elipse button to bring up the large data editor
4) Then I delete some of the text I don't want (still leave most of it)
5) Press the OK button
Here is my first clue nothing happened because the 'Post changes' checkbox isn't highlighted.
6) Now I execute the 'commit'
7) Query everything back up and nothing has changed.
Is there a bug with the version of PL/SQL developer I'm on against the database version? We previously had Oracle database version 9.2.0.5 and I had no problems with the steps above.
Any advice would be greatly appreciated.
Thanks
 
Back
Top