ORA-06502

[dan_sam_78]

Oracle version : 8

Devart version : 7.7

while running a stored procedure with 153 i/p param and 1 o/p param, I am getting "ORA-06502: PL/SQL: numeric or value error: character string buffer too small".

[Shalex]

Are you using CHAR columns or parameters? If yes, try using VARCHAR2 instead.

If this doesn't help, give us the following information:
1) the exact versions of your Oracle server and Oracle client
2) the build number (7.7.XX) of your dotConnect for Oracle
3) send us a small test project with the corresponding DDL/DML script to reproduce the issue in our environment

[dan_sam_78]

Thanks for your quick response

I tried adding all parameters manually through code.

command.Parameters.Add("param_name", OracleDbType.VarChar).Value = paramValue
............

Its working fine.

Previously I was adding parameters dynamically, since there are about 157 IN and 1 OUT parameter.