Re: Oracle NEXTVAL Best Practice
Frederik Soete
Hi, Just a WAG... Physical transactions would be separate, wouldn't they? So what if your upper batch task has instead a deferred transaction, begin at group prefix, and the lower batch task has within active or nested transaction, but it is still executed (I assume) before the upper statement is finally committed? Does grouping all of those related SQL statements into one 'huge' transaction have the desired effect? I do not know Oracle SQL, but am just brainstorming... Frederik Op 16 aug. 2017 18:35 schreef "Steven Blank" <sgblank@...>: Addendum to this, |
|