Purpose

Enables bulk load protocol options for batch inserts that the driver can take advantage of when the EnableBulkLoad property is set to a value of true.

This property only applies to connections to Oracle 11g R2 and higher database servers.

Valid Values

0 | 128

Behavior

If set to 0 or unspecified, the bulk load operation continues even if a value that can cause an index to be invalidated is loaded.

If set to 128, the NoIndexErrors option stops a bulk load operation when a value that would cause an index to be invalidated is loaded. For example, if a value is loaded that violates a unique or non-null constraint, the driver stops the bulk load operation and discards all data being loaded, including any data that was loaded prior to the problem value.

Default

0

Data Type

int

See also

Using DataDirect Bulk Load