Re: Trigger not compiling

Hi gamaz,

gamaz schrieb:
>
> 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,

                 ^^^
                :old

> 12 user, timestamp);
> 13 end if;
> 14 /
>

What is 'timestamp'? Or do you mean 'sysdate'?

hth
peter Received on Fri Nov 08 2002 - 01:19:18 CST