Help Me (Oracel Trigger Problem)

From: Kang, Dale <cs20-15_at_kccedu.co.kr>
Date: Sat, 12 Dec 1998 14:07:28 +0900
Message-ID: <QUmc2.26$ME4.474_at_news.bora.net>

Why this routine don't work ?
Please help me!
[Quoted] I really appreciate your reading.

CREATE OR REPLACE TRIGGER get_hacker

   BEFORE UPDATE OF sal ON emp
   FOR EACH ROW
   WHEN (old.job != 'PRESIDENT')
BEGIN
   INSERT INTO guard(hacker, mod_date, old_sal, new_sal)

      VALUES(user,
         to_char(sysdate,'yy/mm/dd hh24:mi:ss'),
         :old.sal, :new.sal);

   RAISE_APPLICATION_ERROR(-20500,
      'You may olny update Salary of PRESIDENT. !!');

END;
/ Received on Sat Dec 12 1998 - 06:07:28 CET