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" <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 Tue Jan 01 2002 - 04:49:09 CST