I am trying to create a trigger on a table in Oracle that will create a sequence each time a row is inserted into a table. When I try to compile the trigger I get a message that the trigger is invalid.

The syntax I am using is:

create or replace trigger on_part_insert
before insert on PART
for each row
select PART_ID_seq.nextval
into :new.PART_ID
from dual;

The table definintion is

create table part(part_id number, part_number char(30))

Please help!!!!