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

From: Vincent <adonai_at_wish.net>
Date: Thu, 26 Jul 2001 19:21:52 +0200
Message-ID: <3b6051b7$0$13153@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 - 12:21:52 CDT