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


The information in this article applies to:

  • Microsoft OLE DB Provider for Oracle 2.0
  • Microsoft OLE DB Provider for Oracle 2.1
  • Microsoft OLE DB Provider for Oracle 2.5
  • Microsoft OLE DB Provider for Oracle 2.6
  • Microsoft OLE DB Provider for Oracle 2.7
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.2927
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.3513
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.3711
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.4202
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.4403
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.5303
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.6019
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.6526
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.7326
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.7626
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.7713.2
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.
Modification Type:MajorLast Reviewed:8/12/2004
Keywords:kbDatabase kbDriver kbOracle kbprb kbProvider KB298965 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.