REPOST: Trigger won't allow use of a sequence 
Author Message
 REPOST: Trigger won't allow use of a sequence

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

Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.misc


Date: Wed, 2 Jan 2002 00:48:26 GMT
Organization: Navix Internet Subscribers
Lines: 2

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)

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



Sat, 19 Jun 2004 18:49:09 GMT
 REPOST: Trigger won't allow use of a sequence

for sequences, you have to select from a table.

select mysequence.nextval into your_variable from dual

this should work

regards

NP



Quote:
> 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
Quote:

> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.misc
> Subject: cmsg cancel


Quote:

> Date: Wed, 2 Jan 2002 00:48:26 GMT
> Organization: Navix Internet Subscribers
> Lines: 2
> Message-ID:


Quote:
> 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)

> 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



Wed, 23 Jun 2004 18:40:43 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Trigger won't allow use of a sequence

2. REPOST: Newbie: trigger with sequences

3. Trigger using DBMS_PIPE won't parse

4. Allow pg_dump to dump sequences using NO_MAXVALUE and

5. Allow pg_dump to dump sequences using NO_MAXVALUE and NO_MINVALUEb

6. Allow pg_dump to dump sequences using NO_MAXVALUE

7. DTS into table won't allow duplicates

8. HELP: Foreign key won't allow nulls

9. upsized from Access won't allow to add record with null

10. DTS SQL Task won't allow temp tables

11. Security Manager won't allow SA in

12. HELP: Foreign Key won't allow nulls


 
Powered by phpBB® Forum Software