None of the current or in beta Oracle data providers or OLE DB providers actually support Oracle composite types (ARRAY or TABLE). Or OBJECT types, for that matter. The only ways I've heard of to use Oracle composite types is either Java/JDBC or OO4O (which is mostly usable in .NET through COM interop).
Bob Beauchemin [EMAIL PROTECTED] -----Original Message----- From: Dean Bostic [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 10:16 AM To: [EMAIL PROTECTED] Subject: [DOTNET] OleDbParam and Oracle Composite types 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. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.