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

PCC-00055: Array "string" not allowed as bind variable at line number in file string

1 Answers  


ORA-02425: create table failed

1 Answers  


ORA-02487: Error in converting trace data

1 Answers  


IMG-00524: mismatched quotes

1 Answers  


IMG-00732: specified inputChannels could not be found in input image

1 Answers  






ORA-19028: Invalid ADT parameter passed to toObject() function

1 Answers  


ORA-30502: system triggers cannot have INSERT, UPDATE, or DELETE as triggering events

1 Answers  


TNS-03509: OK (number msec)

1 Answers  


ORA-13641: Task cannot be interrupted yet. You may cancel it instead.

1 Answers  


LSX-00332: bad decimal digits in a quantifier specification

1 Answers  


ORA-28556: authorization insufficient to access table

1 Answers  


ORA-01102: cannot mount database in EXCLUSIVE mode

1 Answers  


Categories