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

Last updated on AUGUST 03, 2016

Applies to:

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

Symptoms

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms