Select Non-Lob Columns Across A Dblink Results In Ora-22992

(Doc ID 366122.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 10.2]
Information in this document applies to any platform.


Using ANSI join syntax on a remote table

Select of a remote table using a join causes :

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

There is a lob column in the table but this is not referenced. i.e the error is

select t1.col1, t2.col1 from t1 JOIN t2 ON t1.col1 = t2.col1;

tables have the form :
create table tab1 (col1 number, col2 clob);
create table tab2 (col1 number, col2 clob);


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms