Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

PROC-00018: The value size passed is too large

1 Answers  


PLS-00617: at least one result in the CASE expression must not be NULL

1 Answers  


RMAN-06909: WARNING: parallelism require Enterprise Edition

2 Answers  


SQL*Loader-00640: Variable length field was truncated.

1 Answers  


ORA-17508: I/O request buffer ptr is not alligned

1 Answers  


ORA-16123: transaction string string string is waiting for commit approval

1 Answers  


ORA-03204: the segment type specification should indicate partitioning

1 Answers  


DRG-12229: special section string already exists in this section group

1 Answers  


ORA-13210: error inserting data into the index table

1 Answers  


UDE-00051: unable to set NLS_NUMERIC_CHARACTERS to required defaults.

1 Answers  


ORA-36698: (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.

1 Answers  


ORA-29298: Character set mismatch

1 Answers  


Categories