PL/SQL Developer/Sequences

[iolani]

What am I doing wrong?
I try to get a sequencenumber by using the following SQL-Statement in a PL/SQL-Function/Procedure:
SELECT SEQ_UPVerbindungen.Nextval INTO UPVID FROM DUAL;
UPVID is of the right type, but I get the following error:
ORA-01422 exact fetch returns more then requested number of rows
I also tried DISTINCT, but it didn't work either :-(
The sequence is designed with increment 1 and Nocache option.
I'm desperately looking for help. Even though it's not absolute correct forum, I hope find some answers here.
Thanks for any ideas!

So long!

 

[Marco Kalter]

It would seem that your dual table contains more than 1 row! What do you get when you execute a 'select * from dual' statement in a SQL Window? You should get 1 row, with 1 column (dummy) that contains the value 'X'. Delete any extra rows that exists in the dual table.

------------------
Marco Kalter
Allround Automations

 

[iolani]

You were absolutely right! 2 Rows - 1 deleted - worked. Thanks for helping!