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