Wednesday 1 February 2012

ORA-04096: trigger string has a WHEN clause which is too large, limit 2K

ORA-04096: trigger string has a WHEN clause which is too large, limit 2K

Cause: A trigger s when clause is limited to 2K for dictionary storage reasons. The trigger being created exceeded that size.

Action: Use a smaller when clause. Note, the trigger body could be used to perform the same limiting action as the when clause.

No comments:

Post a Comment