Problem with PL/SQL / nextval

From: Niklas Mehner <wombat_at_uni.de>
Date: Thu, 19 Aug 1999 12:34:47 +0100
Message-ID: <7pgmke$i5k@news.Informatik.Uni-Oldenburg.DE>

I'm using Oracle 8.1.5.

When executing the following script I get a "ORA-01422: exact fetch returns more than requested number of rows" :

SQL> run
  1 DECLARE
  2 icounter number(11);
  3 BEGIN
  4 Select SEQ_LEITUNG.NEXTVAL INTO iCounter FROM Dual;   5* END;
DECLARE
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 4

... but how can there be more than one row !?!

SQL> select seq_leitung.nextval from dual;

NEXTVAL

1636

Please help !

thnx, Niklas Received on Thu Aug 19 1999 - 06:34:47 CDT