My Oracle Support Banner

ODPM: Database PLSQLAssociateArray Returning Datatype DECIMAL Instead Of VARCHAR2 (Doc ID 2739577.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

Using ODP.NET Managed provider when application calling OracleCommandBuilder.DeriveParameters method with PLSQL Package which includes plsql array parameters and it returns
PLSQLAssociateArray. While returning it returns incorrect data type, for example it returns DECIMAL instead of VARCHAR2.

C# code:

 

Changes

 Database upgraded from 12.2.0.1 to 18c or 19c

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.