ORA-08002: sequence CYB_RECEIPT_NO.CURRVAL

From: Denis ALEXANDRE <alex_at_apro.fr>
Date: Mon, 10 May 1999 18:21:11 +0200
Message-ID: <7h719n$cft@dns.apro.fr>

Select NEXTVAL from the sequence before selecting CURRVAL.

Exemple:

---

SQL> select CHQALD_SEQ.currval from dual; ERROR:
ORA-08002: sequence CHQALD_SEQ.CURRVAL is not yet defined in this session

---

SQL> select CHQALD_SEQ.nextval from dual;  NEXTVAL

---

       1

---

SQL> select CHQALD_SEQ.currval from dual;  CURRVAL

---

       1

---

• Original Message ----- From: Syed Faisal Shah <faisal_at_cyber.net.pk> Sent: Saturday, May 08, 1999 5:42 PM Subject: ora-08002

> When i do a select on my sequence to look at currval, it gives me the
following
> error although the nextval is generating correct number and I have around
ten
> thousand numbers from this sequence.
>
> select cyb_receipt_no.currval from dual
>
> ORA-08002: sequence CYB_RECEIPT_NO.CURRVAL is not yet defined in this
session

Denis ALEXANDRE, http://alexnet.apro.fr/ Received on Mon May 10 1999 - 11:21:11 CDT