Referencing DBMS_LOB.COPY() Against Remote Table Fails With ORA-22992
(Doc ID 158924.1)
Last updated on JANUARY 29, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 8.0.6.0 to 8.0.6.3 [Release 8.0.6]Information in this document applies to any platform.
Symptoms
- symptom: Error occurs referencing DBMS_LOB.COPY()
- symptom: Program references remote table
- symptom: Table with LOB column
- symptom: ORA-22992: cannot use LOB locators selected from remote tables
- symptom: Querying a CLOB across database link fails
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |