FIX: 50 or More Output Parameters Produces "Unspecified Error" with the OLE DB Provider for Oracle (259941)
The information in this article applies to:
- Microsoft Data Access Components 2.5
- Microsoft Data Access Components 2.5 SP1
- Microsoft OLE DB Provider for Oracle 2.0
- Microsoft OLE DB Provider for Oracle 2.1
- Microsoft OLE DB Provider for Oracle 2.5
This article was previously published under Q259941 SYMPTOMS
Under the following conditions:
- you are using the Microsoft OLE DB Provider for Oracle to connect to Oracle 8i database
-and-
- you are running a stored procedure inside of a package that returns 50 or more output parameters
an "Unspecified Error" is generated by the Microsoft OLE DB Provider for Oracle.
The error does not occur when the stored procedure returns 49 or fewer output parameters. It also does not occur if 50 or more output parameters are returned but you are using the Microsoft OLE DB Provider for ODBC.
CAUSE
Because of changes in Oracle between version 7.3/8.0 and version 8i, the Microsoft OLE DB Provider for Oracle does not communicate with 8i in the same manner it did with 7.3/8.0.
RESOLUTION
To temporarily work around this problem, you can use the Microsoft OLE DB Provider for ODBC.
STATUSMicrosoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
This problem was corrected in the Microsoft OLE DB Provider for Oracle included in Microsoft Data Access Components (MDAC) 2.6.
Modification Type: | Major | Last Reviewed: | 10/17/2003 |
---|
Keywords: | kbBug kbfix KB259941 |
---|
|