通过DBLINK连接获取longraw字段的数据,引发ORA-01406: fetched column value was truncated的错误
数据库为10G
驱动为msdaora.1
网上的解决方案都试过了,还是失败0.0,在线等,有人遇到过吗
------解决思路----------------------
没事到过,知道clob不能通过dblink查
------解决思路----------------------
恩,有大对象的表,可以通过CREATE TABLE 方式把数据弄到本地,然后再做处理
不知道能不能满足你的需求
------解决思路----------------------
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.