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 APRIL 17, 2023

Applies to:

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


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):


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.