Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to use CURRVAL with a sequence generator?

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US