ArrayBind question....
105804Mar 6 2003 — edited Mar 6 2003I have a .NET program which passes two arrays to a stored procedure using ArrayBind. The stored procedure need to use the values passed to update some records, but how do differentiate between the values of the arrays which are passed, here's an example:
productid = 21, unit_level = 354 log_time = some time
i have two arrays, one for field name and one for data (i have done this due to ODP.NET not allowing multi-dimensional arrays to be used with ArrayBind).
my update statement is:
UPDATE p_products SET UNIT_LEVEL = strData WHERE productid = strData;
but it is updating the unit_level with the first piece of data to be read, i.e. the productid.
how can i get to the second value in the data array?
thanks for your help