ORA-22992: cannot USE LOB locators selected FROM remote TABLES

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.