I'm not sure this is the same thing.
Both DB2 and Oracle support "array inserts" and "array updates", where
an insert or update statement is executed with a list of values - i.e.
it is a more efficient way of executing the same insert/update multiple
times with a different list of values every time. AFAIK, that's what
the bind_param_array() and execute_array() methods are used for. I am
not sure whether DBD::DB2 currently supports this feature.
I'm talking about a different feature, where a single parameter to a
stored procedure, which will be executed a single time, is given a
variable-sized array of values (i.e. an array datatype). An example
would be a stored procedure with a signature like
CREATE PROCEDURE inArray (IN input IntArray)
I think PostgreSQL supports the same feature, but I may be wrong.
Anyway, that's what I'm looking for, not the bind_param_array() and
execute_array() methods.
Hildo
sco...@pythian.com wrote:
DBD::Oracle supports it
if you mean this
$sth->bind_param_array(1,\...@in_values);
$sth->bind_param_inout_array(2,\...@out_values,0,{ora_type => ORA_VARCHAR2});
$sth->execute_array({ArrayTupleStatus=>\...@status});
in this case I am binding an array in and also binding an array on the way
out and I use the execute_array to do it.
No sure if DBD::Oracle will help much is it is useing OCI on the back end.
Cheers
Current releases of DB2 support an array datatype, where a list of
values is passed as a single parameter. The current release of DBD::DB2
does not support this.
Does anyone know of DBD drivers for other databases that implement an
array datatype and that I could use as an example?
Cheers, Hildo
