Page 1 of 1

ORA-01406 - Fetched column value was truncated

Posted: Wed 03 May 2006 14:23
by Guest
Hello,

i am using ODAC Net 5.70.0.28 for Delphi 2006 in a DLL. With one statement i get this error when it is the first time executed. In all subsequent executions (always with a program restart) i don't get this error but the string field is truncated to 32 characters.

Field.DataType is 1 (ftString) and Field.DataSize is 33.

To provoke the error again i have to change the statement slightly (e.g. by inserting a space without changing the semanticy of the statement).

When i use your components with the Net option, all works perfectly:

Field.DataType is 1 (ftString) and Field.DataSize is 2001.

Posted: Thu 04 May 2006 12:51
by Challenger
Similar problem was fixed in ODAC 5.70.0.30. Please try upgrading to it. If the problem still exists
please specify the version of Oracle server and client you use. Send to ODAC support address complete sample that demonstrates this problem and include script to create server objects.

ORA-01406

Posted: Thu 04 May 2006 15:50
by icd
Hello,

i have downloaded the newest version and i still get the error. I have sent you a mail to [email protected] with an test application to reproduce the error.