create database link linkname connect to user identified by usrpwd using 'demona';//demona为用net8 easy config创建的连接字符串insert into newtable select col1,col2... from oldtable@linkname;
不是DB-LINK的问题,我就是在同一个模式下倒也不行啊
blobfld和wordcontent是long raw类型insert into blobtable(myid,blobfld) select 92,wordcontent from t_webword where wordid='2002_09_19_14_28_03_147';ORA-00997: 非法使用 LONG 数据类型declare lr long raw; begin select wordcontent into lr from t_webword where wordid='2002_09_19_14_28_03_147'; insert into blobtable(myid,blobfld) values(92,lr); commit; end;ORA-06502: PL/SQL:数字或值错误 ORA-06512: 在line 3
connect to user
identified by usrpwd
using 'demona';//demona为用net8 easy config创建的连接字符串insert into newtable select col1,col2... from oldtable@linkname;
select 92,wordcontent from t_webword where wordid='2002_09_19_14_28_03_147';ORA-00997: 非法使用 LONG 数据类型declare lr long raw;
begin
select wordcontent into lr from t_webword where wordid='2002_09_19_14_28_03_147';
insert into blobtable(myid,blobfld) values(92,lr);
commit;
end;ORA-06502: PL/SQL:数字或值错误
ORA-06512: 在line 3