I get the error during using pl/sql associative array…

its suddenly happends after i add new output varchar2 on stored procedure parameter

this is the naive solution, basically you have to set ArrayBindSize for parameter OUT with type VARCHAR2


if(parameter.Direction ==ParameterDirection.Output && parameter.OracleDbType==OracleDbType.Varchar2)
 {
var arrayBindSize = new int[arraySize];
for (int iArray = 0; iArray < arraySize; iArray++)
{
arrayBindSize[iArray] = 4000;
}
 parameter.ArrayBindSize = arrayBindSize;
 }

and thats it…

Advertisements