Oracle Forms (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center