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