Large Data Editor: Ora-01480 bug?

[Roeland]

Hi,

create table test
(tekst varchar2(4000 char))

In sql window:
select t.*, t.rowid from test

Insert data into "tekst".

When the size goes above 1010 bytes I get a strange error when clicking on the "Post changes"

ora-01480: trailing null missing from STR bind value

Writing the same data into this field using an update clause works ok.

So I guess there's something wrong with the large data editor.

Also the displayed size changes when entering change mode.

Roeland

PL/SQL Developer 8.0.4.1514

 

[Claus Pedersen]

Also, refer to the post Large Data Editor Problem, which, I beleive, addresses the same issue?

 

[Roeland]

Claus,

you are absolutely right. It's the same issue. I should search better next time.

I have added some extra info about changing display sizes though...

The questions now are:
- Can they reproduce it?
- Will they fix it?

Roeland

 

[Roeland]

This seems fixed in V9 beta!