Using DataDirect Bulk Load on Oracle

DataDirect Bulk Load offers a one-stop approach for all of your bulk load needs, with a simple, consistent way to do bulk load operations for all of the DataDirect Connect products that support this feature (see Using DataDirect Bulk Load).

Configuring DataDirect Bulk Load

You can configure the protocol that the data provider uses to perform bulk loads by setting the Bulk Load Protocol connection string option.

By default, the data provider attempts to use the database's bulk protocol for all bulk operations. If the bulk protocols cannot be used, the data provider uses the best parameter protocol possible for the database.

Alternatively, the data provider can be set to use array binding or the bulk protocol for all bulk load operations. In the latter case, if the bulk protocols cannot be used, the load operation fails with an exception.

Native to XML Schema Data Type Mappings

The following table shows how native OracleDbTypes are mapped to XML schema data types for the bulk load configuration file.

Mapping OracleDbType Enumerations to XML Schema Data Types

Limitations

The Oracle data provider uses array binding instead of DataDirect Bulk Load in the following situations:

• The Oracle server is an older version of Oracle 8 or Oracle 9i.
• External transactions are being used.

The Oracle data provider currently does not support the use of LONG and LONG RAW data types with array binding.