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