SQL & PL/SQL

Greetings,

I use a Transformation tool(Datastage) to load the data from one table to another. But when the source data is read I get this error.

ORA-01406 fetched column value was truncated.

When I run this query generated by the tool in Oracle client it works fine.

Please let me know what is the possibility of this error.

Thanks in Advance
Badhri ...

P.S:

The doumentation says,

Cause: In a host language program, a FETCH operation was forced to truncate a character string. The program buffer area for this column was not large enough to contain the entire string. The cursor return code from the fetch was +3.

Action: Increase the column buffer area to hold the largest column value or perform other appropriate processing.