skip to main content
Using the driver : Configuring Bulk Load : Bulk Load limitations
  

Try DataDirect Drivers Now

Bulk Load limitations

Bulk load is supported for Oracle9i R2 and higher with the following limitations.
*A bulk operation is not allowed in a manual transaction if it is not the first event.
*Once a bulk operation is started, any non-bulk operation is disallowed until the transaction is committed.
*Because of Oracle limitations, issuing a SELECT statement to determine a row count may return different results before and after a bulk load operation.
*Native bulk insert operations are not supported on views.
*The operation INSERT INTO ... SELECT ... is not supported by the bulk load API.
*Oracle does not support literal values in a bulk load operation. You must use parameter markers for all columns being loaded.