Re: one problem with sequence currval?

From: MarkyG <markg_at_mymail.tm>
Date: 14 Aug 2001 01:55:35 -0700
Message-ID: <ab87195e.0108140055.4a1717db@posting.google.com>

You have to use sequence.nextval somewhere before you can use the .currval.

HTH, Mark

sohelcsc_at_yahoo.com (Leader) wrote in message news:<b1a93c73.0108130024.5797eb0d_at_posting.google.com>...
> hi all,
> i am facing a problem with sequence currval , that is, if i insert
> rows from sql prompt, then i can get the currval for the sequence. but
> if i insert it from java programming interface i can't get the currval
> for that sequence. my statement is like this
> select <sequence_name>.currval from dual;
> it is giving error like
> session is not defined yet
> invalid column name
> but from sql prompt its working only problem with java programming
> interface.
>
> hoque
Received on Tue Aug 14 2001 - 03:55:35 CDT