Path: news.easynews.com!easynews!news.he.net!newsfeed.direct.ca!look.ca!news.noc.cabal.int!resurrector!guidorepost!not-for-mail From: "Lee Crampton" Subject: REPOST: Trigger won't allow use of a sequence Newsgroups: comp.databases.oracle.misc X-Repost-Date: 2 Jan 2002 20:50:15 GMT Message-ID: <2$--$$-$-%-$__$%_$@news.noc.cabal.int> X-Original-Path: sn-us!sn-xit-03!supernews.com!194.159.255.21.MISMATCH!dispose.news.demon.net!demon!diablo.netcom.net.uk!netcom.net.uk!newspeer.clara.net!news.clara.net!news5-gui.server.ntli.net!ntli.net!news2-win.server.ntlworld.com.POSTED!not-for-mail X-Original-Message-ID: X-Original-NNTP-Posting-Host: 62.254.25.77 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Date: Tue, 1 Jan 2002 10:49:09 -0000 X-Complaints-To: abuse@ntlworld.com X-Trace: news2-win.server.ntlworld.com 1009882152 62.254.25.77 (Tue, 01 Jan 2002 10:49:12 GMT) NNTP-Posting-Date: Tue, 01 Jan 2002 10:49:12 GMT Organization: ntl Cablemodem News Service Sender: resurrector@mindspring.com (Guido the Resurrector) X-Reposted-By: resurrector@mindspring.com (Guido the Resurrector) X-Comments: GtR Repost: The following Usenet article was cancelled, more X-Comments: than likely by someone other than the original poster. Please X-Comments: see the end of this posting for a copy of the cancel. X-Comments: Guido the Resurrector can be contacted at X-Comments: resurrector@mindspring.com. Lines: 31 Xref: easynews comp.databases.oracle.misc:74367 X-Received-Date: Thu, 03 Jan 2002 09:49:32 MST (news.easynews.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 ========= WAS CANCELLED BY =======: Path: news.uni-stuttgart.de!uni-erlangen.de!news-nue1.dfn.de!news-lei1.dfn.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: "Lee Crampton" Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.misc Subject: cmsg cancel Control: cancel Date: Wed, 2 Jan 2002 00:48:26 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: 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@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