Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ArrayBind question....

105804Mar 6 2003 — edited Mar 6 2003
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 3 2003
Added on Mar 6 2003
6 comments
505 views