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.

Reply via email to