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..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

EXP-00030: Unexpected End-Of-File encountered while reading input

1 Answers  


ORA-37083: Invalid object string

1 Answers  


ORA-25141: invalid EXTENT MANAGEMENT clause

1 Answers  


NNL-00575: list_objects: list all objects in a domain or subtree

1 Answers  


QSM-01015: GROUP BY clause has non-columns

1 Answers  


ORA-00025: failed to allocate string

1 Answers  


ORA-16225: Missing LogMiner session name for Streams

1 Answers  


ORA-07563: sldext: $PARSE failure

1 Answers  


ORA-00488: RBAL process terminated with error

1 Answers  


ORA-28154: Proxy user may not act as client 'string'

1 Answers  


ORA-02789: Maximum number of files reached

1 Answers  


ORA-32114: Cannot perform operation on a null LOB

1 Answers  


Categories