Hi,

This is an Oracle DB specified limit and not something that can be increased. 

If data from a LONG or LONG RAW column can be converted to a constrained datatype (such as CHAR and VARCHAR2 ), then a LONG or LONG RAW column can be referenced in a SQL statement within a trigger. The maximum length for these datatypes is 32000 bytes.

Please review trigger code to identify the column breaching the max length limit and adjust it. This should resolve your issue.

Hi @Hanane 

You need to reduce the number of columns/attributes in the “only when these attributes are changed” section. I don’t know your exact use case here but you could try to always trigger the event and then move the logic to the event action instead.

Or you could split this up into multiple events.

Cheers,
Pete

Indeed when I reduce the number of columns in the “only when these attributes are changed” section , I don’t get the error message .

Thank you All,

Hanane