Has anyone had any success passing the Oracle composite types (VARRAY or
TABLE) as command parameters? For example, if I want to pass an array of
employee id's to Oracle and have it select all the employees in that list,
using Oracle 8.1.7 & System.Data.OleDb namespace:
Dim oParam as OledbParam("emp_id_list")
oParam.OleDbType = <???>
oParam.Value = new Integer() {1, 2, 3, 4}
oCmd.CommandText = "Select * from emp where emp_id in (?)"
oReader = oCmd.ExecuteReader
You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.
