想把SQL2000的IMAGE字段的内容导入到oracle的BLOB类型,就是写不进库(程序不报错)
blob lbol_text,lbol_null
setnull(lbol_null)
for ll_row = 1 to ll_rows
li_id=dw_1.getitemnumber(ll_row,"id")
SELECTBLOB content into :lbol_text from abxx where id=:li_id using sqlca;
messagebox('',string(lbol_text))//可以显示出得到文本
updateblob hw_text set content=:lbol_null where id=:li_id using sqlorcl;
commit using sqlorcl;
updateblob hw_zlgf_text set content=:lbol_text where id=:li_id using sqlorcl;
commit using sqlorcl;
next
------解决方案--------------------
会不会是ORACLE字段类型问题?