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
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 - 09:24:18 CDT
![]() |
![]() |