AnsweredAssumed Answered

Problem with SQL: Value too long for column when inserting value into ACT_RU_VARIABLE

Question asked by tkarthik26 on Jun 25, 2015
Latest reply on Jun 26, 2015 by tkarthik26
Hi,

Typically the TEXT_ column in ACT_RU_VARIABLE supports only 4000 bytes. I have a situation where I need to store content of mail as string in this column, which will exceed the varchar2 max bytes. This is throwing SQL exception as "value too long for column".<!–break–>

How to proceed in this situation? Can we split it into two columns i.e TEXT_ and TEXT2_?

Outcomes