Sending arrays to Oracle stored procedures with .NET 02 November 2005 at 00:00
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;