My Oracle Support Banner

Array Binding For Select statment using ODP.Net 19c throws ORA-03146: invalid buffer length for TTC field (Doc ID 2761615.1)

Last updated on MARCH 21, 2021

Applies to:

Oracle Data Provider for .NET - Version 19.1.0.0.0 to 19.1.0.0.0 [Release 12.1]
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)

Symptoms

Trying to do like 'SELECT * FROM T WHERE T.COL1 = : COL1 from .NET, and bind "COL1" parameter to an array throws ORA-03146.

Code (simplified):

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
Cause
Solution


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