Re: REPOST: Trigger won't allow use of a sequence

From: N.Prabhakar <n_prabhakar_at_hotmail.com>
Date: 5 Jan 2002 10:40:43 GMT
Message-ID: <01c195d5$531bfb80$510e0a3d@default>

for sequences, you have to select from a table.

select mysequence.nextval into your_variable from dual

this should work

regards

NP

Lee Crampton <lee_at_avbrief.com> wrote in article <2$--$$-$-%-$__$%_$@news.noc.cabal.int>...
> 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
>
> ========= WAS CANCELLED BY =======:
> Path:

news.uni-stuttgart.de!uni-erlangen.de!news-nue1.dfn.de!news-lei1.dfn.de!news
feed.freenet.de!news2.euro.net!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.n
avix.net!u.n.a.c.4.n.c.3.l.l.e.r

> From: "Lee Crampton" <lee_at_avbrief.com>
> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.misc
> Subject: cmsg cancel

<IugY7.31062$4x4.3581773_at_news2-win.server.ntlworld.com>
> Control: cancel <IugY7.31062$4x4.3581773_at_news2-win.server.ntlworld.com>
> Date: Wed, 2 Jan 2002 00:48:26 GMT
> Organization: Navix Internet Subscribers
> Lines: 2
> Message-ID:

<cancel.IugY7.31062$4x4.3581773_at_news2-win.server.ntlworld.com>
> NNTP-Posting-Host: 166.102.15.34
> X-Trace: iac5.navix.net 1009943309 19888 166.102.15.34 (2 Jan 2002
03:48:29 GMT)
> X-Complaints-To: abuse_at_navix.net
> NNTP-Posting-Date: 2 Jan 2002 03:48:29 GMT
> X-No-Archive: yes
> Comment: Dude, where's my NewsAgent?
> Xref: news.uni-stuttgart.de control:40276166
>
> autocancel
>
Received on Sat Jan 05 2002 - 04:40:43 CST