Re: create assertion?

From: Terry Dykstra <dontreply_tddykstra_at_forestoil.ca>
Date: Thu, 12 Sep 2002 21:48:46 GMT
Message-ID: <2Z7g9.12431$oT6.1075645@news2.telusplanet.net>

You need a ; after each statement, i.e. it should be:

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

--
Terry Dykstra
Canadian Forest Oil Ltd.
"eugene kim" <eugene1977_at_hotmail.com> wrote in message
news:alc6sv$2uq$1_at_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 Thu Sep 12 2002 - 16:48:46 CDT