Re: Trigger Question?

I figured out why I couldn't create a trigger with an "UPDATE OF" a huge number of columns. The reason is the internal ORACLE table all_triggers has a DESCRIPTION of only 2000 characters. The DESCRIPTION is where the column names are stored.

John Stueve

SQL> describe all_triggers;

 Name                            Null?    Type
 ------------------------------- -------- ----
 OWNER                           NOT NULL VARCHAR2(30)
 TRIGGER_NAME                    NOT NULL VARCHAR2(30)
 TRIGGER_TYPE                             VARCHAR2(16)
 TRIGGERING_EVENT                         VARCHAR2(26)
 TABLE_OWNER                     NOT NULL VARCHAR2(30)
 TABLE_NAME                      NOT NULL VARCHAR2(30)
 REFERENCING_NAMES                        VARCHAR2(87)
 WHEN_CLAUSE                              VARCHAR2(2000)
 STATUS                                   VARCHAR2(8)
 DESCRIPTION                              VARCHAR2(2000)
 TRIGGER_BODY                             LONG

--