URGENTT - fetched column value was truncated
Posted: Wed Jun 05, 2002 10:30 pm
Hi,
I have created a simple job which contains 2 OCI plugins and one Transformer. The job is very simple:
Populate the record from table A to Table B thro Transformer. I am using DataStage V4.2. I have tried to run the job but I have got the following error:
HistDelIwSoLine.DWDB_IW_SO_LINE: ORA-01406: fetched column value was truncated.
HistDelIwSoLine - Job name
DWDB_IW_SO_LINE - Source OCI Plugin
Even I have tried view the Data from source table thro OCI plugin, I have got the same error.
Can anyone help me on this???
The Explanation for that Error is:
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.
Thanks
Bala
I have created a simple job which contains 2 OCI plugins and one Transformer. The job is very simple:
Populate the record from table A to Table B thro Transformer. I am using DataStage V4.2. I have tried to run the job but I have got the following error:
HistDelIwSoLine.DWDB_IW_SO_LINE: ORA-01406: fetched column value was truncated.
HistDelIwSoLine - Job name
DWDB_IW_SO_LINE - Source OCI Plugin
Even I have tried view the Data from source table thro OCI plugin, I have got the same error.
Can anyone help me on this???
The Explanation for that Error is:
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.
Thanks
Bala