NCLOB Value Error BUG in 7.1.1.1339

[Johnson]

background:
I had test some unsure data type, because My company want to migration data from MSSQL to Oracle 10g,and then I found the BUG.
OS: MS Windows XP,2003
PLSQL: PLSQLDevolper 7.1.1.1339
Oracle: Oracle 10g Release 10.2.0.3
Server encode:
NLS_LANGUAGE AMERICAN
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16
Client: NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

1.First Create table
create table JOHNSONTEST
(
COLNVAR NVARCHAR2(1998) not null,
COLTIME TIMESTAMP(6) not null,
COLNCLOB NCLOB,
COLCLOB CLOB
);

2.input the test data manual
3.and then the column of COLNCLOB display ,and can't edit,but it's in version of 7.0.2 natural.

GOOD LUCK!

 

[Marco Kalter]

We'll check it out.

 

[Johnson]

How about you check it!

 

[Johnson]

Why the buy still not fix in 7.1.2.1362?

 

[Marco Kalter]

We have not yet been able to reproduce this.

 

[Marco van der Linden]

I had the same problem with a 'regular' CLOB. It turned out that setting 'Preferences\Oracle\Options\Unicode Enabled' to 'Yes' is the culprit. Unchecking the option gave the expected '' return value and allowed the field to be openened in the Large Data Editor.

@Marco: maybe this helps