Re: retreiving CurrVal in a select statement.

From: Manfred Traumueller <manfred.traumueller_at_memo.ikea.com>
Date: 1997/12/02
Message-ID: <01bcfef9$0650c640$2907080a@wn1011.aut.eeurope.ikea.com>#1/1

Hi !

You must use this statement:

select sequencename.CURRVAL from dual;

Best regards
Manfred Traumueller

IKEA
IBS Wr.Neudorf
AUSTRIA Kal Khatib <kal_at_gene.COM> wrote in article <34835F93.EE2D03B0_at_gene.com>...
> How do you get the current value of a sequence in a select statement;
> I try;
> select CurrVal from some_sequence
> I get
> ORA-02201: sequence not allowed here
>
> is it possible using the above method? Or is there another way? I'm
> trying to assign transactions a unique sequence, then pass the assigned
> sequence to the customer for their reference in the same sesison.
>
> thanks for any help.
> Kal.
>
>
Received on Tue Dec 02 1997 - 00:00:00 CST