ora-1031 ora-0488
SQL> desc watchdog.trig
Name Null? Type
----------------------------------------- -------- ----------------------------
TRIG_ID NOT NULL NUMBER(8)
TRIG_RTBLE_ID NUMBER(8)
TRIG_NM NOT NULL VARCHAR2(100)
TRIG_EQN VARCHAR2(1000)
TRIG_EQN_CF VARCHAR2(1000)
CRT_DT NOT NULL DATE
LST_MOD_DT DATE
LST_POOL_DT DATE
TRIP_FLG NUMBER(1)
ACTV_FLG NOT NULL NUMBER(1)
PD_TRIG_ID NUMBER(8)
VOID_FLG NOT NULL NUMBER(1)
column trig_eqn is expression.
When run the following insert statement :
INSERT INTO watchdog.trig(trig_id, trig_rtble_id, trig_nm, trig_eqn, trig_eqn_cf, crt_dt, lst_mod_dt, trip_flg, actv_flg, pd_trig_id)