Using parameter arrays
- Last Updated: October 28, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Oracle Database Wire Protocol 8.0
- Documentation
Beginning with Oracle 9i, Oracle databases natively support parameter arrays, and the Oracle Wire Protocol driver, in turn, supports them. When designing an application for performance, using native parameter arrays for bulk inserts or updates, for example, can improve performance.
Note: The Oracle Wire Protocol driver currently does not support the use of
BLOB, CLOB, LONG, LONG RAW, and XMLType data types with array binding.
Refer to Using arrays of parameters in the Progress DataDirect for ODBC Drivers Reference for more information.