Hello All ,
While saving a new action event , I get this error message .
Does anyone know how to expand the limit ?
Thank you in advance ,
Hanane
Solved
Trigger definition character limit
Best answer by pwlm
Hi
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
+18Hi,
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.
Cheers, Srikanth
1 person likes this
+11Hi
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.