Oracle Error.Dataaccess ORA-06502: PL / SQL: numeric or error value: character string buffer is too small

Question

I am calling a stored procedure from a .NET application. Proc returns an out parameter of type Varchar2. Fet ch out parameter I pass the parameter to the command as an OracleParameter:

parm12 = new OracleParameter("testkey"
                              , OracleDbType.Varchar2
                              , out2
                              , ParameterDirection.Output);

When I execute proc, I get an error

PL/SQL: numeric or value error: character string buffer too small.

Answer 1

Found the answer.

For the OUT parameter, I declared a size up to max varchar - 32767, and it started working.

, OUT VARCHAR2. .NET, VARCHAR2 - . , , , 0 . proc , , 0 , .

, VARCHAR2-32767 # :).

Answer 2

out2 , . , , -, .