what does your insert statement look like? number columns will store 7 digit
numbers.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Guitar George" <a01a01_at_yahoo.com> wrote in message
news:a1c29f53.0204130307.3ec68fc1_at_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:10:08 CDT
