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

TNS-12625: TNS:missing argument

1 Answers  


ORA-31476: a change table data column is missing from the source table

1 Answers  


TNS-12226: TNS:operating system resource quota exceeded

1 Answers  


ORA-40108: input data contains too few distinct target (string) values

1 Answers  


PLS-00543: a PLSQL Table may not contain a nested table type or VARRAY.

1 Answers  


ORA-02052: remote transaction failure at string

1 Answers  


PCC-00063: Reached end of file string before End-of-Statement at line number!

1 Answers  


RMAN-08024: channel string: restore complete

1 Answers  


ORA-25130: cannot modify primary key - primary key not defined for table

1 Answers  


ORA-27062: could not find pending async I/Os

1 Answers  


TNS-00042: INTCTL: CMANAGER already running. Start operation cancelled

1 Answers  


ORA-17502: ksfdcre:string Failed to create file string

1 Answers  


Categories