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.
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...
Hello,
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.