Question

iDesktop 7C中修改过的Oracle数据源在Deskpro.NET 6R中打开报错：“提取列值被截断”,如何解决？

Answer 1

1.先记录下数据源和所有数据集的投影信息

2.执行三条sql语句

update smregister set smprojectinfo = empty_blob() where dbms_lob.getlength(smprojectinfo) > 199;

update smimgregister set smprojectinfo = empty_blob() where dbms_lob.getlength(smprojectinfo) > 199;

update smdatasourceinfo set smprojectinfo = empty_blob() where dbms_lob.getlength(smprojectinfo) > 199;

3.在6R能打开，不过投影信息需要重新设置