Have you considered using the Oracle Managed Provider? It is still in beta, but pretty solid.
Thanks, Shawn Wildermuth [EMAIL PROTECTED] > -----Original Message----- > From: The DOTNET list will be retired 7/1/02 > [mailto:[EMAIL PROTECTED]] On Behalf Of Dean Bostic > Sent: Monday, June 03, 2002 11: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.
