| ORA-06502 issue after 10g migration [message #434171] |
Mon, 07 December 2009 09:54  |
haris
Messages: 3
Registered: June 2009
|
Junior Member |
|
|
Hi,
We have recently migrated from 9i to 10g(10.2.0.4 to be more precise)
the below issue being faced by us after the migration
We have an sp that is returning a large value (truncated to 40 digits by oracle as its number)
this out parameter value is then being assigned to a variable of size 23 and we are getting ORA-06502
numer value too large
we have done a fix for this by rounding it off to 23 before assigning it to the variable The same sp is working fine in case of 9i database and its returning a 12 digit number instead of a 40 digit
please find the psuedo code for the same
sp
(
a t1.age%type
b t1.name%type
c number
d number
)
{
c=1/3;
}
At the calling side
v varchar(23);
sp
(
a t1.age%type
b t1.name%type
c number
d number
)
select to_char(abs(c)) into :v from dual;
here c=0.3333333333333333333333333333333333 that is rounded to 40 digits.
Is there some kind of parameter setting that the error is handled in 9i but not in 10g
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
