trigger - help newbie!

Hi!
I'm a newbie in PL/SQL.
I'm trying to write a trigger which has to update a specific row from a table after someone insert a new row into the same table. This is my code:

CREATE OR REPLACE TRIGGER CHG_DATE_TEST after INSERT ON emp

BEGIN
  update emp
  set emp.hiredate=sysdate
  where (empno=7566);   

end CHG_DATE_TEST;                         

it doesn't work, the trigger doesn't change the row I want to update
(where empno=7566), but it updates the hiredate from the new
(inserted)row.

Thanks for any help.

Sien Received on Thu Aug 16 2001 - 10:29:38 CEST