Is there a way to pass a custom type from C # to Oracle using System.Data.OracleClient?

Question

I searched the Internet for a solution for passing a string array to a stored procedure in Oracle. An “easy” but messy way used a comma-separated string.

I found a pattern from which I created my own TABLE type from VARCHAR2 (200).

I realized that I could use the constructor created by Oracle "behind the scenes" to provide a list of values ​​that in PL / SQL would be considered a TABLE through which I could iterate.

But when I got to C #, I saw that I was unable to create an OracleParameter object that would allow me to use this implicit constructor.

All the samples that I now find on the Internet deal with the Oracle Data Adapter, they do not say anything about System.Data.OracleClient.

Is there any way to achieve this?

Answer 1

Each resource found sends me to ODP and adds that I should not worry about the Microsoft provider, as it will be deprecated in .NET 4.

I think that I am now refusing this, thanks for the help of Alex and Diadistis.