PL/SQL: ORA-00984: column not allowed here
guys,
trigger failing with Ora- below. Can't figure out why. see table desc
thanks...
SQL> CREATE OR REPLACE TRIGGER MONOWNER.TRG_TEST
2 before UPDATE OR DELETE
3 ON MONOWNER.TMON_TEST03
4 REFERENCING OLD AS OLD NEW AS NEW
5 FOR EACH ROW
6 DECLARE
7 ACT_ID_CUR number;
8 ORG_USR_NU_CUR VARCHAR2(8);
9 ORG_USR_ACV_TS_CUR DATE;
10 LTS_UPD_USR_NU_CUR VARCHAR2(8);
11 LTS_UPD_USR_TS_CUR DATE;
12 BEGIN
13 IF UPDATING then
14 select ACT_ID, ORG_USR_NU, ORG_USR_ACV_TS, LTS_UPD_USR_NU, LTS_UPD_USR_TS
15 into ACT_ID_CUR, ORG_USR_NU_CUR, ORG_USR_ACV_TS_CUR, LTS_UPD_USR_NU_CUR, LTS_UPD_USR_TS
_CUR
16 from TMON_TEST03 where act_id = :NEW.ACT_ID;
17 IF :NEW.ACT_ID = :OLD.ACT_ID THEN
18 insert into MONOWNER.TMON_TEST04 values
19 (ACT_ID, :NEW.ORG_USR_NU, :NEW.ORG_USR_ACV_TS,'LTS_UPD_USR_NU',LTS_UPD_USR_TS);
20 END IF;
21 END IF;
22 end;
23 /
Warning: Trigger created with compilation errors.
SQL> sho errors
Errors for TRIGGER MONOWNER.TRG_TEST:
LINE/COL ERROR
-------- -----------------------------------------------------------------
13/11 PL/SQL: SQL Statement ignored
14/73 PL/SQL: ORA-00984: column not allowed here
SQL> desc TMON_TEST03
Name Null? Type
----------------------- -------- ------------
ACT_ID NOT NULL NUMBER
ORG_USR_NU NOT NULL VARCHAR2(8)
ORG_USR_ACV_TS NOT NULL DATE
LTS_UPD_USR_NU NOT NULL VARCHAR2(8)
LTS_UPD_USR_TS NOT NULL DATE