If you are talking about the maximum number of fields in a table, the limits
are Oracle7 -> 255 and Oracle8 -> 1000. It sounds like in your insert
statement the number of 'values' does not match the number of columns in the
table or you are trying to insert to large of a field (ie. the table
definition says varchar2(3) and you are trying to insert 'abcde'.) This
will cause an error.
Kenny Gump
OCP 7.3 DBA
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:26:52 CST
