Lost number variable precision after calling stored procedure
Hi,
I'm migrating some Forms from 6i to 10g.
I have a stored procedure (tested against Database server 9i and XE 11g ).
procedure aa(p_numero in out number) as
begin
p_numero := 1/4;
end;
It assigns 0.25 into the in out parameter.
Now, in the form I have a local procedure like this:
PROCEDURE prueba IS
l_SinPrecision number(12);
l_ConDecimales number(12,2);
l_ConPresicion0 number(12,0);
BEGIN
aa(l_SinPrecision);
aa(l_conDecimales);
aa(l_ConPresicion0);
END;
I expect the following values for each variable:
l_SinPrecision -> 0
l_ConDecimales -> 0.25
l_ConPresicion0 -> 0
But, I get:
l_SinPrecision -> 0.25
l_ConDecimales -> 0.25