Forum Discussion

hb's avatar
hb
Occasional Contributor
7 years ago

db2 stored procedure with decimal datatype gives "CLI0111E Numeric value out of range SQLSTATE=22003

I am executing a db2 stored procedure with decimal(10) as the parameter type, i tried with both adDecimal and adNumeric with size as well, still get the same issue, same procedure call in Oracle and ...
AlexKaras's avatar
AlexKaras
Icon for Champion Level 1 rankChampion Level 1
7 years ago

Hi,

 

Just to double check:

cmdObj.Parameters.Append(prm4);
prm1.size=10;
prm4.Value=mc_id;

 

Is it a typo to reference prm1 instead of prm4 or not?