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 12.1.0.2 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

When using ODP.NET Managed version 12.2.0.1, 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:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/odpnt/ParameterPrecision.html#GUID-10E9507D-7DDA-484B-89D3-9E3F13A59667  
"For Array Bind and PL/SQL Associative Array Bind, Precision applies to each element in the Value property."

 Sample Code :

Changes

Upgraded client to 12.2.0.1 and using Managed ODP.NET

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.