ORA-08002: sequence SEQ.CURRVAL is not yet defined in this session

oerr ora 8002
08002, 00000, "sequence %s.CURRVAL is not yet defined in this session"
// *Cause: sequence CURRVAL has been selected before sequence NEXTVAL
// *Action: select NEXTVAL from the sequence before selecting CURRVAL

SQL> select WAP_PAGE_OPT_SEQ.currval from dual;
select WAP_PAGE_OPT_SEQ.currval from dual
*
ERROR at line 1:
ORA-08002: sequence WAP_PAGE_OPT_SEQ.CURRVAL is not yet defined in this session

SQL> select WAP_PAGE_OPT_SEQ.nextval from dual;

NEXTVAL
----------
3674

SQL> select WAP_PAGE_OPT_SEQ.currval from dual;

CURRVAL
----------
3674

相关日志