Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with seq.nextval in Schema Manager
Bruce Hair wrote:
>
> Help for this beginner Schema Manager user is appreciated.
> I am having a problem with "seq.nextval" in a trigger for a table. The
> trigger body looks like this;
>
> BEGIN
> :new.SEQN := seq.nextval;
> :new.CONTACT_NAME := user;
> :new.CONTACT_DATE := sysdate;
> END;
>
> I am using Access linked tables and I recieve a '4098 Trigger is invalid
> and failed re-validation' error message when inserting a new row.
> Any suggestions?
> Thanks
Rather than :new.SEQN := seq.nextval;, use the following:
SELECT seq.nextval INTO :new.SEQN FROM dual; Received on Thu Jul 10 1997 - 00:00:00 CDT