ORA-01406 - Fetched column value was truncated

Guest · Post by **Guest** » Wed 03 May 2006 14:23

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.

Challenger · Post by **Challenger** » Thu 04 May 2006 12:51

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.

icd · Post by **icd** » Thu 04 May 2006 15:50

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.