My database contains FIELD IS NOT NULL constraint, this constraint is deferrable.
I run bulk insert/update operations using Array Binding with the OracleCommand object, the OracleCommand.ExecuteNonQuery() executed within OracleTransaction context, I expect that the constraint checking will be done only on OracleTransaction.Commit but instead the check is done in OracleCommand.ExecuteNonQuery() resulting constraint error.
My code flow look something like this:
OracleCommand.Text = "My Query"
OracleCommand.Connection = Connection
OracleCommand.ArrayBindCount = n
OracleCommand.ExecuteNonQuery() //ORA-02290: check constraint (FIELD_NOTNULL) violated. Why? this constraint is deferrable