Problem with the editing of CLOBs in PL/SQL Developer

[admin]

One of our developers wrote:
"There's a problem with the editing of CLOBs in PL/SQL Developer, version 6.0.2.880.
If you go in and edit a CLOB a single hex character, '00', is added to the end of the
clob. This also occurs if you edit the clob by loading an external file.

This may seem like a small error but it chokes my XML Parser and I get an exception saying
"Expected EOF character" (i.e. the parser was expected the end of the file and got the extra
'00' hex character instead).

By the way this never occurred on the old version of PL/SQL Developer (version 5.1.6.747).
In that version you could only load the contents of a file into a CLOB. But when you did
that the CLOB contained only what was in the file - No extra character at the end.

BTW I've been through the forum at http://www.allroundautomations.com/plsqldev.html and
can't find this bug reported anywhere."

 

[Marco Kalter]

I cannot reproduce this. Can you let me know your Oracle Client and Server versions, and the exact steps to reproduce this issue?

 

[admin]

Hello Marco,

Here is an info requested:

Oracle Server - Oracle9i Enterprise Edition Release 9.2.0.1.0
Oracle Client - SQL*Plus: Release 9.2.0.1.0 - Production on Tue Sep 21 09:25:34 2004

To reproduce the bug:
1) Choose a table with fields of type BLOB, right mouse-click and choose Edit Data
2) Click on a BLOB field to bring up the Large Data Editor
3) Click on the Hex tab, go to the end of the field and make note of the last character in the field.
4) Edit the field in some way and hit OK to save the edit.
5) Click on the same field again to bring up the Large Data Editor.
6) Click on the Hex tab and go to the end of the field. You will find a single hex character '00' that wasn't there before.
I couldn't find anyway to remove this character from the field.

 

[Marco Kalter]

Thanks, we'll fix it.