Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using a Sequence from within a Trigger
Change it to:
begin
select test1_seq.nextval into :new.testid from dual;
end;
--
Tom Sullivan
ADI Consulting, Inc.
Received on Thu Sep 10 1998 - 18:17:41 CDT