Data Truncation problem

reddy · Post by **reddy** » Wed Jun 14, 2006 8:37 am

Hi Guys,
Good morning.
I am getting data truncation problem.In the source Oracle table column defined as a long varchar but when i used it as varchar in datastage with max length it is telling data truncated.
Please advice me how to handle long varchar data.
Thanks in advance
Reddy

bmnaidu · Post by **bmnaidu** » Wed Jun 14, 2006 9:02 am

Mr Reddy,
Why don't you try LongVarChar in DS? Hope this can solve your problem.

DSguru2B · Post by **DSguru2B** » Wed Jun 14, 2006 9:16 am

What is your target. WHat the length in your source and target?

reddy · Post by **reddy** » Wed Jun 14, 2006 9:28 am

Thanks for your quick responses.
Source and target both are Oracle.
In the source for a particular column they defined it as long varchar but when i used same matadata i am getting "OCI_INVALID_HANDLE" error but when i changed the column data type to varchar data truncation problem happening.

Please advice me.

Thanks
Narasa

DSguru2B · Post by **DSguru2B** » Wed Jun 14, 2006 9:31 am

I want to know the length number of the source and target. Obviously your target length is smaller than your source. You need to either handle that or ask your dba to increase the length of that particular column.