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

Home -> Community -> Usenet -> c.d.o.server -> Store 7 digit number

Store 7 digit number

From: Guitar George <a01a01_at_yahoo.com>
Date: 13 Apr 2002 04:07:19 -0700
Message-ID: <a1c29f53.0204130307.3ec68fc1@posting.google.com>


I am having no luck inserting a 7 digit number into a table, The create Table code looks like this:
createString = "create table STATES " +

					   "(STATE_NAME varchar(32), " +

"REGION varchar(10), " +
"LARGEST_CITY varchar(32), " +
"CAPITAL varchar(32), " +
"POPULATION int)";

I get NUMBER(38) when I do desc STATES. How can I insert a 7 digit number, e.g. 3444165 into this table? I am getting the error, SQLException: ORA-01722: invalid number. It MUST be possible to store population size! Anyone??
Thanks
Guitar George Received on Sat Apr 13 2002 - 06:07:19 CDT

Original text of this message

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