ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-01406: fetched column value was truncated

ORA-01406: fetched column value was truncated

原创 Linux操作系统 作者:tolywang 时间:2007-03-09 00:00:00 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 100分男人的标准
下一篇: 转载的学车日志
请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13170178