I have a SQL statement like:
Select a.m, a.n, a.o, a.p, b.q, b.r, b.s, c.t, c.u,c.v
From a@remote a left join b@remote b on b.m=a.m and b.n=a.n
Left join c@remote c on c.m=a.m and c.m=a.n
Where a.yr=2019
a.class=1
order by a.m
table “a” and “c” don’t have LOB fields, table “b” has a field “Ldesc” which is CLOB, But it is NOT in the select list.
When I ran select statement by itself, the result returns. But if I want to put result set into a table either using “create table….as..” or “insert into …” before the same select statement, I will get ORA-22992 error. What caused this?
Local version :
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
Remote version:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production