訪问oracle数据链路的blob字段值
訪问照片表
select * from zp@dblink1 where a1='11111';
会报错:ora-22992 无法使用从远程表选择的LOB定位器
改为下面方法:
方法一:
drop table temp
Create table temp as select * from
zp@dblink1 where a1='002';
select * from temp;
方法二:
--创建表仅仅需运行一次
Create global temporary table temp on commit delete rows as select * from
zp@zhplink where 1=2;
Create table temp2 as select * from temp where 1=2;
--能够多次运行insert
insert into temp select * from
zp@zhplink where gmsfhm='140502199102260519';
insert into temp2 select * from temp;
commit;
select * from temp2;