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

Answers embedded

Hth,

Sybrand Bakker, Oracle DBA

Yi Jin <yijin_at_wam.umd.edu> schreef in berichtnieuws 8es2j8$ovv_at_rac2.wam.umd.edu...
>
> 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?

Yes

What is the best
> way to retrive the currval without invoke nextval?

You can't
>
> The column is either generated from the sequence, or manuall entered.
>
> Thanks.
>
> YJ
Received on Thu May 04 2000 - 00:00:00 CDT