My Oracle Support Banner

ODPM :PLSQLAssociativeArray Parameter With Precision returns NULL In 12c (Doc ID 2472604.1)

Last updated on FEBRUARY 07, 2019

Applies to:

Oracle Data Provider for .NET - Version and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)


When using ODP.NET Managed version, fetching data from the Oracle database with a PLSQLAssociativeArray Parameter returns NULL if any Precision != 100 (e.g. 28) is set.
Same code works fine with Unmanaged version of ODP.NET.

As per the Oracle documentation specification, the precision will be applied to each element in the array:  
"For Array Bind and PL/SQL Associative Array Bind, Precision applies to each element in the Value property."

 Sample Code :


Upgraded client to and using Managed ODP.NET


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.