Path: news.easynews.com!easynews!peer1-sjc1.usenetserver.com!usenetserver.com!cyclone.bc.net!newsfeed.direct.ca!look.ca!news.noc.cabal.int!resurrector!guidorepost!not-for-mail From: postbus@sybrandb.demon.nl (Sybrand Bakker) Subject: REPOST: Re: Trigger won't allow use of a sequence Newsgroups: comp.databases.oracle.misc X-Repost-Date: 2 Jan 2002 21:24:20 GMT Message-ID: <8$--$$-$-%-___$$$$@news.noc.cabal.int> X-Original-Path: sn-us!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail X-Original-Message-ID: X-Original-NNTP-Posting-Host: 212.238.21.78 Date: 1 Jan 2002 05:40:16 -0800 Organization: http://groups.google.com/ References: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1009892416 24386 127.0.0.1 (1 Jan 2002 13:40:16 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 1 Jan 2002 13:40:16 GMT 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. Xref: easynews comp.databases.oracle.misc:74372 X-Received-Date: Thu, 03 Jan 2002 09:50:28 MST (news.easynews.com) "Lee Crampton" wrote in message news:... > 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@sybrandb.demon.nl (Sybrand Bakker) Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.misc Subject: cmsg cancel Control: cancel Date: Wed, 2 Jan 2002 02:47:13 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: 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@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