Re: Trigger won't allow use of a sequence

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 1 Jan 2002 05:40:16 -0800
Message-ID: <a20d28ee.0201010540.465ac4c6@posting.google.com>

"Lee Crampton" <lee_at_avbrief.com> wrote in message news:<IugY7.31062$4x4.3581773_at_news2-win.server.ntlworld.com>...
> I have a trigger in which I want to say:
>
> mycolumn := mysequence.NEXTVAL;
>
> This results in a trigger compilation error (and that's all the help you get
> ! ).
> I must be misssing something subtle (?).
>
> Any clues gratefully received.
> Thanks in advance.
> Lee

select mysequence.nextval
into :new.mycolumn
from dual;

Hth
Sybrand Bakker
Senior Oracle DBA Received on Tue Jan 01 2002 - 07:40:16 CST