Skip to main content

Obtain correct value from a sequence

Comments

1 comment

  • David Paras

    I changed the local variable $varUniqueID to be this:

    DBQuery {select EMP.ID_SEQ.nextval from dual where $var_LineCounter = $var_LineCounter , $var_EMP_DBConnInfo, true}

    where var_LineCounter is defined as position( ) for each record. This seems to be working as expected and I'm getting a new sequence even with the caching on.

    0

Article is closed for comments.