g3000 wrote:
> sorry Frank,
> I was previously told by Tom the same suggestion.
> The obvious I cant actually give a test case because it
> involves several tables and source code I cant give to reproduce.
> But thanks for your kind reply and here is the error stack below.
>>From my responses the error is in what is returned from my function.
> ORA-06502: PL/SQL: numeric or value error: number precision too large
> ORA-06512: at "SAMS.MM_LIB", line 716
> ORA-06512: at line 1
> ORA-06512: at "SAMS.MM_LIB", line 796
> ORA-06512: at line 1
>
One of the possibilities I suggested :)
Open MM_LIB, and check in the vicinity of line 796
(line 716 will hold the call to the sub program unit
where it actually goes wrong)
--
Regards,
Frank van Bortel
Received on Thu Dec 16 2004 - 04:12:43 CST
