Any way to get seq.currval without using nextval?

I know this is rather petty but it vexes me to burn a sequence number to find out the current value of a sequence as in:

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

ORA-08002 sequence string.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.

Is there any way around this or am I forever vexed?

Thanks,
Gene Hubert
Durham, NC Received on Mon Oct 08 2001 - 07:44:33 CDT