ORA-01406 - Fetched column value was truncated
Posted: 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.
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.