Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle TRIGGER problem for Oracle 8 and/or 9
aha!!! that fixed it thanks
HansF wrote:
> On Thu, 13 Jul 2006 07:11:45 -0700, relipse wrote:
>
> > Here is my trigger below!!! please help with those compile errors!!
> >
> > SQL> CREATE OR REPLACE TRIGGER trg_insertreg19toreg20
> ...
> > 18 VALUES( SEQ_VT_ID.NEXT,
> > 19 :NEW.REG_USER_ID,
> ...
> > -----------------------------------------------------------------
> > 14/10 PL/SQL: SQL Statement ignored
> > 15/31 PLS-00302: component 'NEXT' must be declared
>
> The error message says 'NEXT' is something it does not understand. The
> onlyh 'NEXT' is associated with the 'SEQ_VT_ID' thingy.
>
> If the 'SEQ_VT_ID' thingy is supposed to be an Oracle sequence, you might
> want to use the correct increment operator 'NEXTVAL'.
>
> --
> Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com)
> *** Feel free to correct me when I'm wrong!
> *** Top posting [replies] guarantees I won't respond.
Received on Thu Jul 13 2006 - 10:07:33 CDT