Microsoft KB Archive/298965

= PRB: Microsoft Oracle OLEDB Provider and ODBC Drivers Do Not Support Passing Array Data Types =

Article ID: 298965

Article Last Modified on 8/12/2004

-

APPLIES TO


 * Microsoft OLE DB Provider for Oracle Server 1.0
 * Microsoft OLE DB Provider for Oracle Server 1.0
 * Microsoft OLE DB Provider for Oracle Server 1.0
 * Microsoft OLE DB Provider for Oracle Server 1.0
 * Microsoft OLE DB Provider for Oracle Server 1.0
 * Microsoft Open Database Connectivity 2.5
 * Microsoft Open Database Connectivity 2.5
 * Microsoft Open Database Connectivity 2.5
 * Microsoft Open Database Connectivity 2.0
 * Microsoft Open Database Connectivity 2.5
 * Microsoft Open Database Connectivity 2.5
 * Microsoft Open Database Connectivity 2.5
 * Microsoft Open Database Connectivity 2.5
 * Microsoft Open Database Connectivity 2.5
 * Microsoft Open Database Connectivity 2.5
 * Microsoft Open Database Connectivity 2.5

-



This article was previously published under Q298965



SYMPTOMS
When you attempt to use adArray in ActiveX Data Objects (ADO) to pass an array to an Oracle stored procedure by using the Microsoft OLE DB or ODBC Driver for Oracle, you may receive the following error message:

3421 - Application uses a value of the wrong type.

or

[Microsoft][ODBC Driver Manager] Option Type out of range



CAUSE
Microsoft Oracle OLE DB Provider and ODBC Driver do not support passing arrays to Oracle stored procedures or functions.



MORE INFORMATION
MS Oracle Provider and driver do not support directly passing the PL/SQL RECORD and TABLE data types to stored procedures. This is a limitation of the provider and driver.

Keywords: kboracle kbprovider kbdatabase kbprb kbdriver KB298965

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.