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.

Data source method

setBulkLoadOptions

Default

0

Data type

int

See also

DataDirect Bulk Load