Sequence question

From: Phil Kaufman <philk_at_dbcsmartsoftware.com>
Date: Mon, 24 Feb 2003 12:05:42 -0500
Message-ID: <gHs6a.295$fD1.43170924@mantis.golden.net>

Hi everyone,

This is a sequence question. I'm using Oracle 8.0.5, 8i, and 9i database engines.

I have a question concerning sequences. I get the following error message if I attempt to login into the database, and determine the current value of a sequence by executing the following statement:

select seq_some_sequence.currval from dual

                                 *

ERROR at line 1:
ORA-08002: sequence SEQ_SOME_SEQUENCE.CURRVAL is not yet defined in this session

I've determined that I must first get the next sequence value from the database engine first before doing a CURRVAL on the sequence. My question is; is there a way to determine the current value of a sequence without doing a NEXTVAL first?

Also, I don't remember this being an issue with pre 8 databases, though I can't be sure of that. Not sure if things have changed with sequences since version 7.3.4.

Anyway, any response is welcomed.

Thanks in advance. Received on Mon Feb 24 2003 - 11:05:42 CST