Server crash on calling stored procedure with negative parameter

oleksastep

New Member
I have simple stored procedure like this:
CREATE PROCEDURE pHelloW1 ( IN bonusc NUMERIC(9,2) )
BEGIN
END;

and when I call it with negative parameter
call pHelloW1(-1);

I get error
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=0
[DataDirect][OpenEdge JDBC Driver]A server crash is likely.

Does anybody knows what's wrong? Can't find the answer in documentation and knowledge base...
/OpenEdge Release 10.2A02/

Sincerely,
Alex
 
Are negative values legitimate? What happens when you call it with a positive value?
Yes, negative values are legitimate. With positive values that's all right. I get the error even when running the example, wrote above. Looks like the procedure does't understand negative numeric (decimal) value.
 
Back
Top