Re: HELP: Sequence Problem!!!

From: Gerd Volberg <gerd.volberg_at_netcologne.de>
Date: Fri, 31 Jul 1998 23:07:34 +0200
Message-ID: <35C23215.DCD6B507_at_netcologne.de>


Hi,

first you can use the .CurrVal - InlineFunction:

    Insert into Table () values (Seq_1.NextVal, Seq_2.CurrVal);

An other method, not for this problem, is, using the Value-Column from ALL_SEQUENCES where the SEQ-NAME is your Sequence. Looking into this table means no increase of the sequence, and you can get the actual value of the sequence. You have to you use this, when you havenīt gotten a Seq.NextVal in your session. Then you cannot use the Seq.CURRVAL-Function!

Machīs gut
  Gerd Volberg

Opitz&Partner GmbH
Tel. : +49 2204 72440
EMail: volberg_at_opitz-partner.de Received on Fri Jul 31 1998 - 23:07:34 CEST

Original text of this message