Re: Again a newbie who's begging for some help!

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 Fri Jul 27 2001 - 07:58:24 CDT