ExecuteArray and AutoCommit

ExecuteArray and AutoCommit

Postby 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?
quangnd
 
Posts: 5
Joined: Thu 28 Jan 2010 07:03

Re: ExecuteArray and AutoCommit

Postby 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/appdev.920/a96584/oci16ms2.htm with the OCI_COMMIT_ON_SUCCESS parameter. This OCI function and this parameter are used regardless of whether you call ExecuteArray or ExecuteNonQuery.
Pinturiccio
Devart Team
 
Posts: 1986
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle