Re: Getting current sequence value

From: Mike Rose <mmrose_at_home.com>
Date: Mon, 29 Mar 1999 01:34:17 GMT
Message-ID: <tMAL2.17191$573.6997@news.rdc1.md.home.com>

Why don't you use the following method, it works for me.

SQL/orc1> select Trips_SEQ.NextVal From Dual;

NEXTVAL

105501

SQL/orc1>

Mike Rose

Doug Cowles <dcowles_at_bigfoot.com> wrote in message news:36FECA76.A2A8D15A_at_bigfoot.com...
> Is there any way to get the current value of a sequence number without
> incrementing it? You can't use currval unless you define the sequence
> for the session by calling nextval first. Is there any way around this?
>
> - Dc.
>
Received on Sun Mar 28 1999 - 19:34:17 CST