Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Using Sequence Gen in Trigger
Can a Sequence be used in a insert before row Trigger?
create or replace trigger package_id_trigger
before insert on tracking for each row begin :new.R_45_145_Package_ID := package_seq.nextval;
end;
When I compile this trigger I get a error stating that a Sequence can't be used in this context. It seems you can only use " package_seq.nextval" in an insert statement?
Any input.........
Thanks Rick Ryan.... rickryan_at_global2000.netReceived on Mon Apr 28 1997 - 00:00:00 CDT