My Oracle Support Banner

Error: Java.Sql.Sqlexception: ORA-01406: Fetched Column Value Was Truncated (Doc ID 394259.1)

Last updated on FEBRUARY 03, 2019

Applies to:

JDBC - Version: to - Release: 9.0.1 to 9.2
Information in this document applies to any platform.
Checked for relevance on 07-Dec-2010


There are two databases, one database with a characterset AR8ISO8859P6 (Arabic content) and another  database with characterset UTF8.
A view is created for a table in the other database using database link. When selecting the view from SQL*PLUS there are no problems, but selecting the view with a J2EE application using JDBC throws following error:
  java.sql.SQLException: ORA-01406: fetched column value was truncated.


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.