Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Trigger not compiling
Hi, I am trying to create a trigger. However, it gives me the following
error message. I could not figure out why the error message is coming. Any
help is appreciated in advance. Thanks.
SQL> create trigger emp_a_iurow
2 after insert or update of empno, ename, job, mgr, hiredate, sal,
comm, deptno on
3 emp
4 for each row
5 begin
6 if inserting then
7 insert into emp_log(emp_no, mod_user, mod_timestamp)
8 values(:new.empno, user, timestamp);
9 else
10 insert into employee_log
11 values(:old.empno, :old.ename, :old.job, :old.mgr, :old.mgr,
:old.hiredate, old.comm,
12 user, timestamp);
13 end if;
14 /
Warning: Trigger created with compilation errors.
SQL> l
1 create trigger emp_a_iurow
2 after insert or update of empno, ename, job, mgr, hiredate, sal,
comm, deptno on
3 emp
4 for each row
5 begin
6 if inserting then
7 insert into emp_log(emp_no, mod_user, mod_timestamp)
8 values(:new.empno, user, timestamp);
9 else
10 insert into employee_log
11 values(:old.empno, :old.ename, :old.job, :old.mgr, :old.mgr,
:old.hiredate, old.comm,
12 user, timestamp);
13* end if;
SQL> show error
Errors for TRIGGER EMP_A_IUROW:
LINE/COL ERROR
-------- ----------------------------------------------------------------- 10/0 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin declare end exception exit for goto if loop mod null pragma raise return select update while <an identifier> <a double-quoted delimited-identifier> <a bind variable> << close current delete fetch lock insert open rollback savepoint set sql execute commit forall <a single-quoted SQL string>
SQL> Received on Thu Nov 07 2002 - 23:57:43 CST