ExecuteArray and AutoCommit

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
quangnd
Posts: 5
Joined: Thu 28 Jan 2010 07:03

ExecuteArray and AutoCommit

Post by quangnd » Thu 09 Mar 2017 12:36

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?

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: ExecuteArray and AutoCommit

Post by Pinturiccio » Tue 14 Mar 2017 15:42

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.

Post Reply