triggers

I need to create a trigger in the database but it doesn't seem to be accepting it. I am using sqlplus. Can anyone tell me where I am going wrong?

CREATE TRIGGER update_trig
BEFORE
UPDATE
ON table
BEGIN
   INSERT INTO table2

        VALUES(new.field, 1);
END update_trig;

Sqlplus just waits for more input.

Thanks,
Heather Received on Wed Jan 31 1996 - 00:00:00 CET