My Oracle Support Banner

OLEDB : Unspecified Error Raised When Table has More Records (Doc ID 2979868.1)

Last updated on NOVEMBER 26, 2023

Applies to:

Oracle Provider for OLE DB - Version and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)


Using Oracle OLEDB application, Application attempting to retrieve over 2000 rows, an "Unspecified Error" message is encountered. This issue is exists in the more recent versions of the Oracle OLEDB Provider like 21.x and 19.x. But in earlier versions  18.x and 12.x  does not have problem. Furthermore, this problem is observed in both 32-Bit and 64-Bit client versions.

DB Script:

Steps to reproduce:

1. Create the following table:





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.