Re: why is this trigger not working
From: Kevin Gillins <k.gillins_at_verizon.net>
Date: Wed, 18 Sep 2002 18:08:49 -0400
Message-ID: <amatoh$b10$1_at_nntp-m01.news.aol.com>
Date: Wed, 18 Sep 2002 18:08:49 -0400
Message-ID: <amatoh$b10$1_at_nntp-m01.news.aol.com>
Try ending with a / causing it to be executed.
Kevin
"Rich D" <rdalfonso_at_nyc.rr.com> wrote in message
news:196cd325.0209181326.3c6560f0_at_posting.google.com...
> whenever i run this trigger in SQl Plus - nothing happens. I don't
> even get an indication that it failed to be created.
>
> But is this trigger ok for Oracle
>
>
> CREATE OR REPLACE TRIGGER UpdateInstance
> FOR UPDATE ON Survey_Instance
> AS
>
> DECLARE sp_Survey_instance_id int;
> sp_Survey_instance_id = SELECT Survey_instance_id FROM inserted;
> UPDATE Survey_Instance SET Survey_Instance.Update_datetime =
> SYSDATE WHERE Survey_Instance.Survey_instance_id =
> sp_Survey_instance_id;
> END;
Received on Thu Sep 19 2002 - 00:08:49 CEST