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

ORA-25142: default storage clause specified twice

1 Answers  


PCC-02407: Object and REF types do not match

1 Answers  


ORA-31210: DBMS_LDAP: PL/SQL - LDAP get_dn error.

1 Answers  


ORA-32315: REFRESH FAST of "string"."string" unsupported after mixed DML and Direct Load

1 Answers  


RMAN-20231: ambiguous datafilecopy name

1 Answers  


PLS-01458: The set clause in an UPDATE statement requires a column name of length 1

1 Answers  


ORA-01579: write error occurred during recovery

1 Answers  


ORA-38431: could not evaluate subexpression "string" for rowid "string"

1 Answers  


ORA-23454: flavor string not defined for object group "string"."string"

1 Answers  


NZE-29015: incorrect message length

1 Answers  


ORA-12717: Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR or NVARCHAR2 data exists

1 Answers  


ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)

1 Answers  


Categories