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 Thu Jul 26 2001 - 22:11:55 CDT
