SQL Language (MOSC)

MOSC Banner

ora-1031 ora-0488

edited Jan 21, 2011 4:03PM in SQL Language (MOSC) 1 commentAnswered
I have a table watchdog.trig and set as follow:

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center