auto commit after/before alter sequence?
223157Jul 4 2003 — edited Jul 4 2003Hi,
to improve performance in insert many records (>1.000.000) in a database, we call a sequence to get the first (latest) value and increase it in a programmatic way till 1.000.
At the same time we alter the sequence to assure the next sequence number will be 1.001.
We detect that the alter sequence command set a commit after or before and because we use the same connection the insert will fail.
As a work around we use a 2nd connection for the alter sequence statement, but only for interests, is this a "normal" behaviour? Can I control this?
Kind regards in advanced
Wolfgang