Re: HELP: Sequence Problem!!!

Once you have called nextval in your session, you may use curval. This implies however that you need to be sure that Oracle evaluates the values in the given order:

    strSQL = "INSERT INTO table1 (firstID,secondID) VALUES
(SEQ1.NextVal, seq1.curval) "

I guess you'd better add an extra line to get the nextval into a variable:

    select seq.nextval
    into v_SeqVal
    from dual;

    strSQL = 'INSERT INTO table1 (firstID,secondID) VALUES ( '     || v_SeqVal || ', ' || v_SeqVal || ') ';

Or an update:

    strSQL = "INSERT INTO table1 (firstID,secondID) VALUES
(SEQ1.NextVal, null)"

    update table1
    set secondID = firtstID
    where secondID is null;

Arjan. Received on Fri Jul 31 1998 - 12:38:06 CEST