Oracle-L: RE: How to store Value greater than 38 digits ?? Help !!

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 19 Jun 2002 06:58:22 -0800
Message-ID: <F001.0048127B.20020619065822@fatcity.com>

Shradha - What are you saying?
1. You require more than 38 digits of accuracy? 2. Your number is larger than 38 digits.

If the problem is the first, wow, you must be into something incredible. If the problem is the second, no problem. Data also stores "scale", which can be up to 127. That means 10 to the 127th power.

Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, June 19, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L

Hi DBAs,

One of my projects is facing a problem, they are using a numeric datatype for a column, in the process part the calulation is leading to a number larger than 38 digits.

Therefore they are not getting a result ie procedure is not returning anything.

If you have come across such a thing ?...Inputs are welcome

Thanks and regards,
Shradha
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: arul.kumar_at_bt.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------