ORA-01480: trailing null missing from STR bind value

[Niki Iordanov]

Hi,

We have a AL32UTF8 database with NLS_LENGTH_SEMANTICS=char and a varchar2(4000 char) field. Every time I do an insert into the field using an otString bind variable if the value is larger than 1000 chars it gets truncated and I get the following error: "ORA-01480: trailing null missing from STR bind value". Looks like DOA is trincating the trailing null thus leading to the above error.

Is there a fix/workaround for this. It seems to be inserting fine if I use the otPLSQLString type.

Thanks,
Niki

 

[Marco Kalter]

Have you set TOracleSession.BytesPerCharacter to bcAutoDetect?

 

[Niki Iordanov]

Yes, it's set to bcAutoDetect.

 

[Niki Iordanov]

Why is DOA trncating the value?

The column definition is in chars and it can store up to 4000 chars doesn't matter how many bytes per char there are?

Niki

 

[Marco Kalter]

It is truncated because there is probably an error detecting the character size. Can you let me know the character set of the NLS_LANG Oracle registry key on the client?

 

[Niki Iordanov]

The NLS_LANG is AMERICAN_AMERICA.AL32UTF8

Thanks for looking into this.

Niki

 

[Niki Iordanov]

Is this problem going to be adressed in some of the next releases? If not we'll have to start converting our prameter types to otPLSQLString to avoid the problem. We have a bunch of them in the code.

Niki

 

[Marco Kalter]

We're looking into it.

 

[walter.egger]

well 'they' are looking into this since 13th august 2004 - so far no solution!!!

see my post from 2004 'unicode problem with long strings'

 

[Marco Kalter]

We didn't have Unicode support back then.