Page 1 of 1

ExecuteArray and AutoCommit

Posted: Thu 09 Mar 2017 12:36
by quangnd
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?

Re: ExecuteArray and AutoCommit

Posted: Tue 14 Mar 2017 15:42
by Pinturiccio
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.