ORA-1406: Fetched Column Value was Truncated When Selecting Remote Column into Local BLOB Variable
(Doc ID 459557.1)
Last updated on FEBRUARY 01, 2022
Applies to:Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 188.8.131.52 [Release 10.2 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.2.0.1 to 184.108.40.206
Materialized views can be used as an alternative solution to able to retrieve BLOB columns greater than 32KB - 1 in size through a database link .
Since when selecting a remote column into local BLOB variable in which the length of remote column have a length of 2 Mb and more,the following error occurs:
ORA-01406 : fetched column value was truncated.
Oracle Database Application Developer's Guide - Large Objects 10g Release 2 (10.2)
What's New in Large Objects?
Restrictions Removed in Oracle Database 10g Release 2
Starting from 10g the select from a lob object through a database link is supported by receiving the LOB objects into variables defined as CHAR or RAW.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document