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 - 07:56:01 CDT
