Re: sequence in trigger

From: Peter Schneider <peter.schneider_at_okay.net>
Date: 1998/03/31
Message-ID: <3521725f.7680569@news.ipf.net>#1/1

On Tue, 31 Mar 1998 14:06:42 -0800, Jim Poe <jpoe_at_fulcrumit.com> wrote:

>I need an example of using a sequence in a trigger. I tried this, but
>I get a compiler error saying that the sequence cannot be referrenced in
>this context.
>
>CREATE TRIGGER CUSTOMER_BEF_INS_KEY_ID
> BEFORE INSERT
> ON JIM.CUSTOMER
> FOR EACH ROW
> BEGIN
> :new.KEY_ID:=CUSTOMER_SEQUENCE.NextVal;
> END;
>
>Thanks

Hi Jim,

you can't access a sequence in an expression, you need to use a select statement instead. Try this:

...
 FOR EACH ROW
 BEGIN
   SELECT CUSTOMER_SEQUENCE.NextVal

     INTO :new.KEY_ID
     FROM dual;

 END; HTH
Peter

-- 
Peter Schneider
peter.schneider_at_okay.net

Received on Tue Mar 31 1998 - 00:00:00 CST