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 -> Re: Field too long?

Re: Field too long?

From: Jeff Hunter <jeffh_at_btitelecom.net>
Date: Fri, 24 Sep 1999 15:21:06 -0400
Message-ID: <37ebcf5c@defiant.btitelecom.net>


Most likely, you are trying to stuff a value into a field that won't accomodate it. For example, trying to put "ABCDE" into a char(4) field.

amerar_at_ci.chi.il.us wrote in message <7sg9ih$b0u$1_at_nnrp1.deja.com>...
>
>
>Hello,
>
>I am using SQLLDR in convential path to load some data. More than half
>of the records are giving me this error:
>
>ORA-01401: inserted value too large for column
>
>I'm not sure why since in my control file I specify the length of the
>field and I have compared it with the table...........
>
>Any ideas?
>
>Arthur
>amerar_at_ci.chi.il.us
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Sep 24 1999 - 14:21:06 CDT

Original text of this message

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