I have a problem with the following scenario:
I have an Oracle 8i database with a synonym to Oracle 8.0.5 tables. This Oracle 8 table contains a column of datatype CLOB.
When I try to bring this column over to 8i (using select myclobcol into v_myclobvar from myOracle8Synonym), I get this error:
ORA-22992: cannot use LOB locators selected from remote tables
I have search everywhere for a solution, but cannot find one.
I know that it is specifically an Oracle 8 issue.
Looking forward to your solutions