I am using OracleCommand.ExecuteArray to call a procedure.
If I set OracleConnection.AutoCommit = True, then Commit will execute for each item in array or once at the end?
ExecuteArray and AutoCommit
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ExecuteArray and AutoCommit
In the OCI mode, OracleCommand is executed via the OCIStmtExecute OCI function https://docs.oracle.com/cd/B10501_01/ap ... i16ms2.htm with the OCI_COMMIT_ON_SUCCESS parameter. This OCI function and this parameter are used regardless of whether you call ExecuteArray or ExecuteNonQuery.