We are using a feature of the ODP.NET that allows you to send arrays of parameters to and from stored procedures in Oracle. This is called associative arrays and is described in great detail in this article.
BUT... of course there is a but. This article doesn't describe how to receive arrays back from a stored procedure. This is described here.
The trick (and confusing part) is that the size of the output array needs to be specified a priori (on beforehand) even for output parameters. A bit strange but it works.
Published by
on Last updated