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.
INSERT INTO SELECT statements are not supported.
When designing an application for performance, using native parameter arrays for bulk inserts or updates, for example, can improve performance. Refer to "Designing ODBC Applications for Performance Optimization" in the DataDirect Connect Series for ODBC Reference for more information about using arrays of parameters to improve performance.
A bulk operation is not allowed in a manual transaction if it is not the first event.