Re: Oracle TRIGGER problem for Oracle 8 and/or 9

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Thu, 13 Jul 2006 14:24:18 GMT
Message-Id: <pan.2006.07.13.14.26.18.613649@gmail.com>

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