OK!
now what was the original question?
scy
"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:<0Td97.415897$p33.8430216_at_news1.sttls1.wa.home.com>...
> The volume of the known universe (assuming 15 billion light year radius and
> a sphere) in cubic inches is like a hundred orders of magnitude less than
> the largest number Oracle can handle. (So even switching to cubic nanometers
> it is still about 100 orders of magnitude less!)
> Jim
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3b651f63$0$8509$ed9e5944_at_reading.news.pipex.net...
> > Vincent
> >
> > Sadly this number is beyond Oracle capabilities From the manual
> >
> > The following numbers can be stored in a NUMBER column:
> >
> > a.. Positive numbers in the range 1 x 10-130 to 9.99..9 x 10125 with up
to
> > 38 significant digits
> > and negative numbers in a similar (but not identical) range.
> >
> > I must confess I'm intrigued ,and suspicious of, what numbers you are
> > holding that go to 10^160. In comparison the age of the universe is
> > something like 10^18 seconds (or 16 billion years). Equally the mass of
the
> > earth turns out at 10^24 Kg, or thereabouts.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> >
> > Legal disclaimer required by my employer
> >
> > **
> > This email contains information intended for the addressee only.
> > It may be confidential and may be the subject of legal and/or
professional
> > privilege.
> > Any dissemination, distribution, copyright or use of this communication
> > without prior permission of the addressee is strictly prohibited.
> >
> > **
> > "Vincent" <adonai_at_wish.net> wrote in message
> > news:3b6166ee$0$15204_at_reader5...
> > > Thanks! That's very nice of you. Is troubleshooting your job?
> > >
> > > "Jim Kennedy" <kennedy-family_at_home.com> schreef in bericht
> > > news:%Z487.413662$p33.8417811_at_news1.sttls1.wa.home.com...
> > > > I'll look at this at work.
> > > > Jim
> > > > "Vincent" <adonai_at_wish.net> wrote in message
> > > > news:3b6051b7$0$13153_at_reader4...
> > > > > Hello Jim,
> > > > >
> > > > > First I like to thank you for your reaction.
> > > > >
> > > > > The exact sql statement is:
> > > > >
> > > > > INSERT INTO
> > > > > "ZONES"
> > > > >
> > > >
> > >
> >
("SERIAL","ALIAS_ID1","ALIAS_ID2","ZTYP","ZSTAT","COUNTRY_ID","ADDRESS","NO"
> > > > >
> > > >
> > >
> >
,"ZIP_CODE","GIR_CODE","DESCRIPTION","PARENT_ID","XCORD","YCORD","XTOP","YTO
> > > > >
> > > >
> > >
> >
P","XBOT","YBOT","XLEN","YLEN","ROTATION","SIZE","PICTURENAAM","ICONNAAM","V
> > > > > ALID_YES_NO","COMMENTS")
> > > > > VALUES
> > > > >
> > > >
> > >
> >
('huis','','','HoofdGebouw',NULL,NULL,'',NULL,'','','','Flevoland',NULL,NULL
> > > > >
> > > >
> > >
> >
,0,0,0,0,2.03795089340019E+160,4.84809494615021E-33,NULL,3771.5427114062,NUL
> > > > > L,NULL,'','')
> > > > >
> > > > > The table description is:
> > > > >
> > > > > Name Null? Type
> > > > > ------------------------------- -------- ----
> > > > > SERIAL NOT NULL VARCHAR2(128)
> > > > > ALIAS_ID1 VARCHAR2(128)
> > > > > ALIAS_ID2 VARCHAR2(128)
> > > > > ZTYP VARCHAR2(64)
> > > > > ZSTAT VARCHAR2(16)
> > > > > COUNTRY_ID VARCHAR2(128)
> > > > > ADDRESS VARCHAR2(64)
> > > > > NO VARCHAR2(8)
> > > > > ZIP_CODE VARCHAR2(16)
> > > > > GIR_CODE VARCHAR2(8)
> > > > > DESCRIPTION VARCHAR2(128)
> > > > > PARENT_ID VARCHAR2(128)
> > > > > XCORD NUMBER
> > > > > YCORD NUMBER
> > > > > XTOP NUMBER
> > > > > YTOP NUMBER
> > > > > XBOT NUMBER
> > > > > YBOT NUMBER
> > > > > XLEN NUMBER
> > > > > YLEN NUMBER
> > > > > ROTATION NUMBER
> > > > > SIZE NUMBER
> > > > > PICTURENAAM VARCHAR2(128)
> > > > > ICONNAAM VARCHAR2(128)
> > > > > VALID_YES_NO VARCHAR2(3)
> > > > > COMMENTS VARCHAR2(255)
> > > > >
> > > > > The Oracle version is 8.0.5.0.0
> > > > >
> > > > > I hope you can help me with this one!
> > > > >
> > > > > Some more information: I have an ODBC connection to Oracle and I
> tried
> to
> > > > > execute this SQL within a Visual Basic program. Doing this results
> into
> the
> > > > > error "ODBC-call failed". After that I have tried this SQL within
> TOAD
> and
> > > > > TOAD tells me that it is a numeric overflow problem.
> > > > >
> > > > > Reading the Oracle manuals tells me that the maximum number is
9.99x10^125,
> > > > > but the value I'm trying to put into that number type field is
> 2x10^160.
> So
> > > > > it looks explainable. But it doesn't solve my problem. I need to
> have
> this
> > > > > value in the Oracle database.
> > > > >
> > > > > Thanks again!
> > > > >
> > > > > Regards, Vincent
> > > > >
> > > > >
> > > > > "Jim Kennedy" <kennedy-family_at_home.com> schreef in bericht
> > > > > news:BrU77.410223$p33.8379060_at_news1.sttls1.wa.home.com...
> > > > > > Should work just fine. Can you do a describe on the table that
> you
> are
> > > > > > putting the data into?
> > > > > > In sqlplus do
> > > > > > desc theTableName
> > > > > > Maybe the number is defined to not take it.(you can limit scale
and
> > > > > > precision).
> > > > > > Also what is the sql statement you are using? Try it from
sqlplus.
> > > > > > insert into myTable(col1,col2,...) values( value1,value2,...);
> > > > > > commit;
> > > > > > Jim
> > > > > > "Vincent" <adonai_at_wish.net> wrote in message
news:3b600336$0$7007_at_reader5...
> > > > > > > Hello everybody,
> > > > > > >
> > > > > > > Is it possible to put a value of 2.03795089340019E+160 into a
> number
> field?
> > > > > > > At the moment the value is stored in an Access database double
> type
> field
> > > > > > > and I want to put the data into an Oracle database number type
> field
> but
> the
> > > > > > > query gives the error 'ORA-01426: numeric overflow'. For as far
> as
> I
> know
> > > > > > > there isn't another datatype available in Oracle. Am I wrong? Do
> I
> have
> to
> > > > > > > create an user defined type now? I don't have experience with
> that
> (but
> > > > > > > everything can be learned).
> > > > > > >
> > > > > > > Thanks in advance,
> > > > > > > Vincent
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
Received on Tue Jul 31 2001 - 13:59:26 CDT
