ORA-08002

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

Solution:

Run once the next statement for initialization of sequence:

select seq1.NEXTVAL from dual;

Now, your CURRVAL command works fine.

select seq1.CURRVAL from dual;