Trigger for generating Sequence

Hi, the following trigger is generating Compilation errors :

CREATE TRIGGER test_auto_id BEFORE INSERT ON test for each row BEGIN SELECT test_id.nextval INTO :new.ID from dual ; END

I think it has something to do with my usage of ":new" - Any ideas ?

Thanks.

perhaps you could share the error message with us

No Description. Just a message : "Warning: Trigger created with compilation errors."

type ...

show errors

Thanks Slimdave. Was just missing a ';' at the end - so silly.