torasession.autocommit

lunr · Post by **lunr** » Mon 04 Dec 2006 14:24

hi, i am using ODAC 5.80.0.37, Delphi 7.0 and Oracle 10g.
When i set orasession.autocommit and oraquery.autocommit to true and execute a DML statement, i dont see any commit statement sent to Oracle in DBMonitor. How does ODAC perform commit in this case?
Thank you.

Challenger · Post by **Challenger** » Tue 05 Dec 2006 13:14

When autocommit property is True, ODAC executes statements with the OCI_COMMIT_ON_SUCCESS flag. That's why you do not see commit commands in DBMonitor.