ORA-01406: fetched column value was truncated

This error is definitely because you modified the definition of this column in the table.

The client program is supposed to fetch this column into a varchar2 variable with the same length, then you increased the column in database, which exceeds the length of the client variable, now the client program has to truncate the value fetched from database to fit into the variable.

This is the very scenario where anchored variable is useful.

http://www.itpub.net/showthread.php?threadid=195180&pagenumber=

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-84517/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-84517/