訪問oracle數據鏈路的blob字段值

訪問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;