ORA-06502

ORA-06502

Postby dan_sam_78 » Thu 26 Dec 2013 10:11

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".
dan_sam_78
 
Posts: 2
Joined: Thu 26 Dec 2013 10:02

Re: ORA-06502

Postby Shalex » Thu 26 Dec 2013 16:27

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
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Re: ORA-06502

Postby dan_sam_78 » Sun 29 Dec 2013 10:04

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.
dan_sam_78
 
Posts: 2
Joined: Thu 26 Dec 2013 10:02


Return to dotConnect for Oracle