DataStage job failing with error esql complaint: ORA-12899:

ketanshah123 · Post by **ketanshah123** » Fri Nov 06, 2009 7:44 am

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

chulett · Post by **chulett** » Fri Nov 06, 2009 7:56 am

Multi-byte character set?

ketanshah123 · Post by **ketanshah123** » Fri Nov 06, 2009 9:12 am

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

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

chulett · Post by **chulett** » Fri Nov 06, 2009 10:36 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Nov 06, 2009 2:10 pm

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.

chulett · Post by **chulett** » Fri Nov 06, 2009 2:26 pm

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