Re: create assertion?

From: eugene kim <eugene1977_at_hotmail.com>
Date: Sat, 07 Sep 2002 13:51:35 +0000
Message-ID: <alc6sv$2uq$1@newsreader.mailgate.org>

got one more question..
... is anything wrong with my trigger?

create trigger set_duedate after insert on orders for each row
begin

        update orders set duedate = (select sysdate from dual) end set_duedate;

---

Warning: Trigger created with compilation errors.

---

ORA-04098: trigger 'EUGENE.SET_DUEDATE' is invalid and failed re-validation Received on Sat Sep 07 2002 - 08:51:35 CDT