After Upgrade to 4.2 - ORA-01406
Posted: Thu Jun 06, 2002 4:04 am
Greetings,
We upgraded from 4 to 4.2 and we have a job that has a source and a target oracle oraoci8 plugins with a one-to-one mapping between them. When I run the job I get the below mentioned oracle error in the source plug-in.
ORA-01406 fetched column value was truncated
Please help.
Badhri ..
P.S: From the Documentation.
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.
We upgraded from 4 to 4.2 and we have a job that has a source and a target oracle oraoci8 plugins with a one-to-one mapping between them. When I run the job I get the below mentioned oracle error in the source plug-in.
ORA-01406 fetched column value was truncated
Please help.
Badhri ..
P.S: From the Documentation.
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.