How to solve Oracle Database Error 8002 (ora-08002)

Oracle Error Code
   ora-08002

Description
   sequence string.CURRVAL is not yet defined in this session

Cause
   sequence CURRVAL has been selected before sequence NEXTVAL
How to Solve
   select NEXTVAL from the sequence before selecting CURRVAL
Posts About Oracle Database Error ORA-08005
DBA:
This error occurs when you used a sequence the first time after the creation.

SEQ.NextVal must be called at least one time before using SEQ.CurrVal.

If you received this error, be aware that your sequence is not
initialized yet.
Call only one time seq.nextval and your sequence will be initialized.
Then you can use seq.currval freely.


Do you have question or do you know about solution ?

Share with us. (No registration required)
  
Your Name
Question, comment or solution
Similar Errors
  ORA-08000    ORA-08001    ORA-08002    ORA-08003    ORA-08004    ORA-08005  Others

Main Page      Contact Us      Tools & Softwares      Server Monitoring Softwares