ORA-01406: fetched column value was truncated
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.
iam getting the above in toad but iam unable to rectify it.
how to increase the column buffer area what option we have to chk for that
What were you doing in Toad when you got the error? If you were running your own PL/SQL code then the problem may be in your code. If you were performing DML, the problem could be in a trigger. Otherwise, the problem may be a Toad bug.