Sending arrays to Oracle stored procedures with .NET

You can send arrays to Oracle stored procedures as parameters.

Add an OracleParameter object, setting it’s type to the underlying type of the array, e.g.

OracleDbType.Int32

After that, set the CollectionType property of the OracleParameter as follows:

yourParm.CollectionType = OracleCollectionType.PLSQLAssociativeArray;