The driver supports native parameter arrays in Oracle 9i and higher databases with the following limitations:
A bulk operation is not allowed in a manual transaction if it is not the first event.
Bulk inserts into views are not allowed.
Once a bulk operation is started, any non-bulk operation is disallowed until the transaction is committed.
The Oracle Wire Protocol driver currently does not support the use of BLOB, CLOB, LONG, LONG RAW, and XMLType data types when using bulk load for parameter array batch.
Because of Oracle limitations, issuing a SELECT statement to determine a row count may return different results before and after a bulk load operation.
Oracle does not support literal values in a bulk load operation. You must use parameter markers for all columns being loaded.
A bulk operation is not allowed in a manual transaction if it is not the first event.