Collected posts: Oracle, SQL, PL/SQL, Performance, Security...(More than 300 blogs)

dimanche 29 novembre 2015

ORA-22992: cannot use LOB locators selected from remote tables

 

ORA-22992: cannot use LOB locators selected from remote tables

--- Remote DB
create table CHB_TEST 
(
 DATA CLOB  

);
--- LOCAL DB
select   DATA    from CHB_TEST@<ORACLE_DB_LINK_REMOTE_DB> 

ORA-22992: cannot use LOB locators selected from remote tables

 select dbms_lob.substr@<ORACLE_DB_LINK_REMOTE_DB>( DATA , 4000) from CHB_TEST@<ORACLE_DB_LINK_REMOTE_DB