ORA-22992: cannot USE LOB locators selected FROM remote TABLES
Error
Error occured while tried to access the SQL query of DBLINK.
ORA-22992: cannot USE LOB locators selected FROM remote TABLES
SELECT sales_item_description
FROM sales_north@SALE_DBLINK
WHERE sales_id = 785;
FROM sales_north@SALE_DBLINK
*
ORA-22992: cannot USE LOB locators selected FROM remote TABLES
Cause
LOB column does not able to check from the DBLINK.
Solution
We cannot access CLOB or BLOB columns from the database link.