Re: Help Me (Oracel Trigger Problem)

[Quoted] You need to provide a little more on this problem. Does it update the president or just the people not the president. Also see if the trigger is compiled and accurate using enterprise manager.

"Kang, Dale" wrote:

> Why this routine don't work ?
> Please help me!
> 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 Mon Dec 28 1998 - 02:20:53 CET