Re: Subsequent call to seq_name.nextval. Please help.

From: Andrew Hardy <nobody_at_spam.from.news.AdvanticaTech.com>
Date: Fri, 22 Jun 2001 14:04:01 +0100
Message-ID: <9gvfr3$37q$1@sun-cc204.lut.ac.uk>

"Silver" <boltsilver_at_hotmail.com> wrote in message news:ad3752b9.0106211313.66bd170c_at_posting.google.com...
> cursor c_cust_id is select seq_customer_id.nextval from dual;
> begin
> open c_cust_id;
> fetch c_cust_id into val;
> if mod(val,2) = 1 then
> fetch c_cust_id into val;
> end if;
> close c_cust_id;

That doesn't seem quite right - how are you managing to get two fetches from dual? Surely you should close and then open-fetch-close once more?

Andy Received on Fri Jun 22 2001 - 08:04:01 CDT