Oracle version 8.1.6+
VB/VC code using ADO to connect to the database via the Microsoft Oracle provider

How can you pass an array of integers or longs in VB to a stored procedure using ADO? For example, the application determines a list of numeric identifiers and wants to pass them to a stored procedure in a single invocation.

What is the proper data type to define for the argument to the procedure in the database? TABLE or VARRAY or OBJECT type?

How exactly would you define the ADO command parameter to pass that array as an argument to the stored procedure? (We have tried using adArray || adInteger but get an error from the MS Oracle provider.) Are we going about things the wrong way or are we specifying the wrong array type for the parameter?

A brief example would really be appreciated.

Thanks,

Heath