ODP.NET - ArrayBindSize and Size for PLSQLAssociativeArrays
November 13, 2008
I have written about this before but I’ll make a short recap since it has to do with some quite interesting stuff in Oracle.
With ODP.NET you can harness the full power of Oracle’s features such as, for example, using Associative Arrays to bulk stuff into the database. We are using this feature in my current application since it will handle big loads.
OK - so far so good. I cannot understand two things and we have now involved the full brainpower of the team and still are scratching our heads. It actually boils down to two properties on the OracleParameter-class; Size and ArrayBindSize.
- The Size-property should be (in the case of using associative arrays) set to the number of elements in the array. The strange thing though is that the value of the property must be set for output-parameters. I mean - how...