Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-04096: trigger 'string' has a WHEN clause which is too
large, limit 2K
- 1 Answers
- 4022 Views
- I also Faced
- E-Mail Answers
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 |
ORA-22920: row containing the LOB value is not locked
DRG-50947: ABOUT clause not allowed without a theme index
ORA-24022: the specified parameters has no effect on the queue
ORA-12504: TNS:listener was not given the SID in CONNECT_DATA
ORA-03286: ALLOCATE EXTENT not valid for HASH CLUSTERS
ORA-38303: invalid option for PURGE TABLESPACE
LFI-00139: Option string cannot be used with option string in calling string.
ORA-02822: Invalid block offset
ORA-26522: rpc execution error
PLS-00211: CASE labels or ranges must not be duplicated in different WHEN clauses
PCC-02370: An EXEC TOOLS MESSAGE host variable is not type char
ORA-12452: label tag string already exists
Oracle Errors 
