Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Store 7 digit number
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