寒 寒芳轻 Unregistered / Unconfirmed GUEST, unregistred user! 2008-05-13 #1 在网上找了好多，都没有给出解决方法~~~~~<br> sql的text字段对应oracle的clob字段？<br>复制 粘贴ms行部通<br>有命令可用么？
B ball_cao Unregistered / Unconfirmed GUEST, unregistred user! 2008-05-13 #2 query1连sql select * from sql表<br>query2连oralce select * from oracle表<br>TBlobField(query1.fieldbyname(???)).savetostream(sm);<br>TBlobField(query2.fieldbyname(???)).loadfromstream(sm)
query1连sql select * from sql表<br>query2连oralce select * from oracle表<br>TBlobField(query1.fieldbyname(???)).savetostream(sm);<br>TBlobField(query2.fieldbyname(???)).loadfromstream(sm)
D DIGUA Unregistered / Unconfirmed GUEST, unregistred user! 2008-05-13 #3 CLOB BLOB两个还是有点区别的,没试过,不知道是否存在兼容问题
寒 寒芳轻 Unregistered / Unconfirmed GUEST, unregistred user! 2008-05-14 #4 额，text对应的是clob型的吧~~~~~~~~<br> image对应的好像是blob型的吧~~~~~~~~~~
夜 夜叶也1111 Unregistered / Unconfirmed GUEST, unregistred user! 2008-05-16 #5 用2个adoconnection分别连接sql和orcle<br>然后用两个adoquery连接sql的源表，和oracle的目标表<br>循环插入数据
