How to get ride of ORA-01426: numeric overflow error?

[tamilselvan]

Hi Folks,
Thanks for your responses about my doubt..

Slimdave... can you please give some more clear idea about whats the need of putting N = 100 as default value.?..

Tamil.. Can you please throw some lights on your answer " Use IBM or FORTRAN "??

Thanks in advance.

Happy Thanks Giving!!!

Regards,
Kumar

If you can access IBM supercomputer and then use FORTRAN language or C language, to calculate all FAC values, and then use the results in Oracle's function. The function will return varchar2 instead of float.
Oracle RDBMS is not designed for Scientific calculation.

Tamil

[slimdave]

Slimdave... can you please give some more clear idea about whats the need of putting N = 100 as default value.?..

I was cheating by using a precalculated value. Note that I changed the return type of the function to varchar2 also.