oracle中有一表ta_img上有一字段img 的类型是long raw,img是用来存相片,是个人头像,在另一台服务器的sql server中建立DB LINK后
可以通过
select * from openquery (ER, 'select idno, img from ER.ZZ021VV where idno=''20090101'' ')
来select 语句
后来因某种原因,ta_img导入另一台的服务器,img的类型变为BLOB
直接select * from openquery (ER, 'select idno, img from ER.ZZ021VV where idno=''20090101'' ') 来
select 时总提示OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: 发生了一个 Oracle 错误,但无法从 Oracle 中检索错误信息。]
[OLE/DB provider returned message: 数据类型不被支持。]
OLE DB error trace [OLE/DB Provider 'MSDAORA' ICommandPrepare::Prepare returned 0x80004005: ]. 用 select * from openquery (ER, 'select idno, sys.UTL_RAW.CAST_TO_RAW(utl_raw.cast_to_varchar2(img)) img from ER.ZZ021VV where idno=''20090101'' ') 后能select 了,但是显示图片是,只出来头发,就是有可能用了函数后二进制流少了
可以通过
select * from openquery (ER, 'select idno, img from ER.ZZ021VV where idno=''20090101'' ')
来select 语句
后来因某种原因,ta_img导入另一台的服务器,img的类型变为BLOB
直接select * from openquery (ER, 'select idno, img from ER.ZZ021VV where idno=''20090101'' ') 来
select 时总提示OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: 发生了一个 Oracle 错误,但无法从 Oracle 中检索错误信息。]
[OLE/DB provider returned message: 数据类型不被支持。]
OLE DB error trace [OLE/DB Provider 'MSDAORA' ICommandPrepare::Prepare returned 0x80004005: ]. 用 select * from openquery (ER, 'select idno, sys.UTL_RAW.CAST_TO_RAW(utl_raw.cast_to_varchar2(img)) img from ER.ZZ021VV where idno=''20090101'' ') 后能select 了,但是显示图片是,只出来头发,就是有可能用了函数后二进制流少了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货