Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Again a newbie who's begging for some help!

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

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Sat, 28 Jul 2001 02:17:28 GMT
Message-ID: <Ygp87.414727$p33.8422176@news1.sttls1.wa.home.com>

I have all my tools and an Oracle database at work. I am an Oracle dba, and a programmer and so trouble shooting comes as part of the job. Been at this for awhile.
Jim
"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 Fri Jul 27 2001 - 21:17:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US