My Oracle Support Banner

OraOLEDB Throws AccessViolationException When OleDataAdapter.Fill Is Issued to A Table Which Has Large Rowsize (Doc ID 2918399.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Provider for OLE DB - Version 19.7.0.0.0 to 21.3.0.0.0 [Release 19.0 to 12.1]
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

After applying WINDBBP 19.7.0.0.200414 or later version, an OraOLEDB application throws System.AccessViolationException with the following call stack when OleDataAdapter.Fill is issued to retrieve data from a table which has a large rowsize like 264,000 bytes(4,000 bytes * 66 columns).

The problem can reproduce if the query returns the number of records is greater than the value of FetchSize.
That is, if FetchSize is 100 (Defaut) and the number of records is 100, the application will work, but if FetchSize is 100 and the number of records is 101, the application will fail.

Changes

Apply WINDBBP 19.7.0.0.200414 or upgrade to 21c.
 

Cause

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
Symptoms
Changes
Cause
Solution
References


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