Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Trigger not compiling

Trigger not compiling

From: gamaz <gamaz_at_eathlink.net>
Date: Fri, 08 Nov 2002 05:57:43 GMT
Message-ID: <rnIy9.944$Aq5.83187@newsread2.prod.itd.earthlink.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US