My Oracle Support Banner

ORA-22992 When Trying To Select Lob Columns Over A Database Link (Doc ID 119897.1)

Last updated on FEBRUARY 10, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


This document discusses whether or not a lob column can be selected over a 
remote database link.


This document is written for all audiences.
This information is based on the tests made in Oracle 8.1.5 and Oracle 8.1.6 
and the available Oracle documentation on LOB (large Object) data and issues 
logged with Development on the select of a LOB column over a remote database 


To view full details, 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 a vibrant support community of peers and Oracle experts.