Is it possible to read a CLOB from a remote Oracle database?

Question

This answer on a question on SO says

... you can read a LONG from a remote database, but you can't read a CLOB

I did not find anything about this on the internet, is it true? Any documentation or citings for this will be helpful.

Answer 1

The answer is correct in a certain context, for simple select statements over a DB link, you'll get this error:

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

From the errors manual:

Cause: A remote LOB column cannot be referenced.
Action: Remove references to LOBs in remote tables.

I also had trouble finding definitive documentation on this...but we just ran into the same issue in our data warehouse. However, there are several work-arounds available, pulling the data over or creating a view for example.