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

Home -> Community -> Usenet -> c.d.o.server -> Problems with trigger creation.

Problems with trigger creation.

From: gamaz <gamaz_at_eathlink.net>
Date: Thu, 07 Nov 2002 21:30:40 GMT
Message-ID: <4YAy9.18$Aq5.4417@newsread2.prod.itd.earthlink.net>


Hi, I have written an after insert update trigger. However, while running it is giving error.
I am new to trigger. Could someone give me advise how to handle the errors here. Thanks
in advance. Regards.

SQL> CREATE TRIGGER emp_a_iurow

   after insert or update of employee_id, last_name, first_name, middle_initial,

   dept_id, title, supervisor_id on employee    for each row
   begin
   if inserting then
   insert into employee_log(employee_id, mod_user, mod_timestamp)    values(:new.employee_id, username, timestamp);      else
    insert into employee_log
     values(:old.employee_id, :old.last_name, :old.first_name, :old.middle_initial,

    :old.title, old,supervisor_id, username, timestamp);    end if;
   end;

  /

Warning: Trigger created with compilation errors.

SQL> show error;
Errors for TRIGGER EMP_A_IUROW:

LINE/COL ERROR

-------- -----------------------------------------------------------------
3/1      PL/SQL: SQL Statement ignored
4/26     PLS-00201: identifier 'USERNAME' must be declared
6/1      PL/SQL: SQL Statement ignored
7/93     PLS-00201: identifier 'OLD' must be declared
SQL> Received on Thu Nov 07 2002 - 15:30:40 CST

Original text of this message

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