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
Aucun commentaire:
Enregistrer un commentaire