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.