Re: How do you retrive the CURRVAL of the sequence from a servlet?

From: Mike Blake <blakemj_at_my-deja.com>
Date: 2000/05/04
Message-ID: <8es5ll$4sa$1@nnrp1.deja.com>#1/1

select sequence.currval from dual;

That should give you the current sequence value.

Mike
In article <8es2j8$ovv_at_rac2.wam.umd.edu>, yijin_at_wam.umd.edu (Yi Jin) wrote:
>
> I need to put the current value of a sequqnce in a text field in a
> servlet. How do you retrive it from JDBC?
>
> Do I have to invoke nextval before retrive currval? What is the best
> way to retrive the currval without invoke nextval?
>
> The column is either generated from the sequence, or manuall entered.
>
> Thanks.
>
> YJ
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu May 04 2000 - 00:00:00 CDT