In the example that you provided you can simply remove all references to AutoCommit. By default AutoCommit will be false, and in the next version there will not be any AutoCommit property. You have to explicitly manage your transactions through commits and rollbacks.

The only component that does any implicit transaction management is the TOracleDataSet. By default it will commit any posted or deleted record. If something goes wrong during this process, it will rollback any changes it made. If you are using CachedUpdates, posted and deleted records will not immediately be applied to the database, and will therefore not be committed or rolled back either. Now you must use TOracleSession.ApplyUpdates, CancelUpdates and CommitUpdates to manage the transaction.

For all other components that can modify the database (TOracleQuery, TOraclePackage, TLOBLocator and TOracleObject), you must also explicitly commit or rollback these modifications.


------------------
Marco Kalter
Allround Automations