这篇博客详细讨论了在数据库操作中遇到ORA-01406错误的场景，提供了原因分析和相应的解决方案，帮助读者理解和避免此类问题。
ORA-01406: fetched column value was truncated
-----------------------------------------------
服务端：AMERICAN_AMERICA.WE8ISO8859P1
服务端：AMERICAN_AMERICA.WE8ISO8859P1
客户端：AMERICAN_AMERICA.ZHS16GBK
客户端，通过toad 修改rka091中的一个varchar2的值，提交后，再次查询。报出ORA-01406的错误。
-----------------------------------
修改客户端的环境变量为，AMERICAN_AMERICA.WE8ISO8859P1，重新启动toad后， 查询正常。
-----------------------------------
修改客户端的环境变量为，AMERICAN_AMERICA.WE8ISO8859P1，重新启动toad后， 查询正常。
From Oracle document...
ORA-01406 fetched column value was truncated
Cause In a host language program, a FETCH operation was forced to truncate a character string. The program buffer area for this column was not large enough to contain the entire string. The cursor return code from the fetch was +3.
Action Increase the column buffer area to hold the largest column value or perform. other appropriate processing.
Action Increase the column buffer area to hold the largest column value or perform. other appropriate processing.
最低0.47元/天 解锁文章
扫一扫
2369
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
