DSXchange

Hi

My job failing with error esql complaint: ORA-12899: value too large for column

error is coming while updating , the field which giving error has length 40 before database stage there is trnasfpormer stage and in transformer have derivition like
if isnull(columnname) then setnull() else left(columnname, 35)

in database also the filed is having lenght 40.

I have used tring in transformer , substring in sql but still same error persists. Source is SAP system and filed is coming only 40 char from there side.

Any clues,solution for this

thanx in advance

Multi-byte character set?

chulett wrote:Multi-byte character set? ...

the field I am getting from DataSet and is of type char with length 40

Doesn't really answer the question. What character sets are involved here, source and target?

What Craig is getting at with his question is that, depending on what character set you are using, it may require more than 40 bytes to store 35 characters. Oracle can be specified to allocate storage in either bytes or characters.

And the default is bytes. And yes, was... getting there.