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 AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.1]
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: to
**Checked for relevance on 26-Dec-2013***


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

my_ad LONG RAW;
my_tid VARCHAR2(20);
SELECT tid, fileobject INTO my_tid, my_ad FROM pbrs_v_document_instance_00 WHERE ROWNUM=1;
DBMS_OUTPUT.PUT_LINE ( ' Le tid s�lectionn� est ' || my_tid);



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.