How to get ride of ORA-01426: numeric overflow error? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

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

  1. #11
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Quote Originally Posted by Kumar_RP
    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

  2. #12
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Quote Originally Posted by Kumar_RP
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width