Trigger for generating Sequence

[rshivagami]

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.

[slimdave]

perhaps you could share the error message with us

[rshivagami]

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

[slimdave]

type ...

show errors

[rshivagami]

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