DatabaseLink不支援merge和lob欄位查詢

在測試中，發現DatabaseLink不支援merge、lob欄位查詢（支援lob插入），共享一下。

--1，版本
SQL> select * from v$version;
 
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Productio
NLSRTL Version 10.2.0.3.0 - Production
 
--2，merge操作
SQL>
SQL> MERGE INTO
  2  USING dual
  3  ON (user_id = 24268439)
  4  WHEN MATCHED THEN
  5    UPDATE SET session_id = 'aa', crt_date = SYSDATE
  6  WHEN NOT MATCHED THEN
  7    INSERT
  8      (user_id, session_id, crt_date)
  9    VALUES
 10      (24268439, 'bb', SYSDATE);
 
ORA-01008: not all variables bound
ORA-02063: preceding line from DB_LINK_20_97

 --3，查詢含lob欄位的表
SQL>
SQL> select * from
  2  ;
 
select * from
 
ORA-22992: cannot use LOB locators selected from remote tables

--插入
SQL> insert into
  2  select * from transa where rownum<2;
 
1 row inserted