Oracle 7.X allows 254 (or is it 255) fields and Oracle 8 allows 1,000.
Try insert into customer (fieldName1,fieldName2...) values (....);
Maybe it is an individual column that is not large enough. Also try it from
sqlplus, if you are using another application it might have a limit in its
driver.
Jim
MAMASTA wrote in message <19990119224013.09327.00000945_at_ng-fd1.aol.com>...
>What is the max number of fields you can have in an Oracle database file?
>I am working with about 100 fields....some as large as 40 characters.
>It seems that I can create the data format with no problem but when usint
the
>INSERT INTO CUSTOMER
>values("fsafsaf","dfajsfdlj",......etc), it gives me an error saying that
the
>number of values are too big...
>
>I was able to INSERT values into 40 fields with no problem....but over 90
gave
>me an error msg.
>
>Is this a bug or an Oracle limitation?
>FoxPro can handle over 100 fields....is this going back into the past?
>
> Oracle
>Newb........
Received on Wed Jan 20 1999 - 07:08:05 CST
