通过database link查询远程数据库表,其中该表含有clob字段,结果出现错误ORA-22992
我通过查询metalink,人家说不能调用含有LOB字段的远程表
其中有一个文档有以下语句
you cannot select a lob column using remote dblink. You have to use
DBMS_LOB package in a programming language like PL/SQL, JAVA to manipulate LOB data.
我通过查询metalink,人家说不能调用含有LOB字段的远程表
其中有一个文档有以下语句
you cannot select a lob column using remote dblink. You have to use
DBMS_LOB package in a programming language like PL/SQL, JAVA to manipulate LOB data.