文章存档
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2008-06-30 16:16:50
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.
自己遇到了好多次这个问题，我遇到的问题一般是：
如：
tab1(col1 varchar2(20));
表中col1字段本来长度是20的，但我在oci中取该字段数据用的长度小于20就出现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.
自己遇到了好多次这个问题，我遇到的问题一般是：
如：
tab1(col1 varchar2(20));
表中col1字段本来长度是20的，但我在oci中取该字段数据用的长度小于20就出现ora-01406问题了.
给主人留下些什么吧！~~