My Oracle Support Banner

ORA-1406: Fetched Column Value was Truncated When Selecting Remote Column into Local BLOB Variable (Doc ID 459557.1)

Last updated on FEBRUARY 01, 2024

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 to [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: to


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.