How to use CURRVAL with a sequence generator?

From: Ubiquitous <weberm_at_polaris.net>
Date: Wed, 24 Nov 2004 15:15:06 +0000 (UTC)
Message-ID: <co28hq$ms2$1@news.utelfla.com>

I am attempting to write some PL/SQL which will look at a sequence generator which is used to create receipt numbers and determine if assigning n receipts will exceed its last value (the sequence was created with the NONCYCLE option).

However, my attempts to use CURRVAL return some sort of "unidentified value this session" ORACLE exception if I do not use NEXTVAL, yet I am able to see the last value used in TOAD.

Is there a way to replicate what I am seeing in TOAD? Received on Wed Nov 24 2004 - 09:15:06 CST