Stored Procedure with Associative Array as Parameter

Hello,

When we call a stored procedure in which one parameter is an Associative Array type, the method of OracleCommandBuilder.DeriveParameters of Oracle client doesn't return the correct number of parameters.

We have this problem only with Oracle 18c Database (the same stored can be executed into Oracle 12c Database without any problem).

We have tried to test the procedure with different oracle client version, but the problem occurs in all cases.

The version of Database is Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.3.0.0.0

Follow one example:

create or replace package test_package

as

type ref_cursor is ref cursor;