REPOST: 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: <8$--$$-$-%-___$$$$@news.noc.cabal.int>

"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

WAS CANCELLED BY =======: Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news2.euro.net!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: postbus_at_sybrandb.demon.nl (Sybrand Bakker) Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.misc Subject: cmsg cancel <a20d28ee.0201010540.465ac4c6_at_posting.google.com> Control: cancel <a20d28ee.0201010540.465ac4c6_at_posting.google.com> Date: Wed, 2 Jan 2002 02:47:13 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.a20d28ee.0201010540.465ac4c6_at_posting.google.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009943302 19888 166.102.15.34 (2 Jan 2002 03:48:22 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 2 Jan 2002 03:48:22 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? Xref: news.uni-stuttgart.de control:40276154

autocancel Received on Tue Jan 01 2002 - 07:40:16 CST