Binding Arrays of Parameters in ADO and ODBC
Posted on 2002-05-15
In ODBC there was possibility to bind array of values to parameter.
In ODBC documentation we read:
When an application uses array of parameters, there are two different ways this can be executed. One way is for the driver to rely on the array-processing capabilities of the back end, in which case the entire statement with the array of parameters is treated as one atomic unit. Oracle is an example of a data source that supports array processing capabilities.
This is what we really need and we always use for Oracle.
But now we deal with ADO and we find no similar features.
We can create Parameter object and assign a value for it. But how array of values can be assigned?