I have this "simple" Stored Procedure.
If i try to execute i get this error.

Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements.
Integer overflow. The result of an integer operation caused the most
significant bit of the result to carry.

Why? What is the meaning? What can i do?



CREATE PROCEDURE NEW_PROCEDURE
AS
DECLARE VARIABLE D1 NUMERIC(18,6);
DECLARE VARIABLE D2 NUMERIC(18,6);
DECLARE VARIABLE D3 NUMERIC(18,6);
DECLARE VARIABLE D4 NUMERIC(18,6);
DECLARE VARIABLE DS NUMERIC(18,6);
begin

D1 = 1 ;
D2 = 2 ;
D3 = 3 ;
D4 = 4 ;

DS = (1 - D1/100) * (1 - D2/100) * (1 - D3/100) * (1 - D4/100) ;

end