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
