Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Unable to load a string of length 356 into VARCHAR2(2000) column

Unable to load a string of length 356 into VARCHAR2(2000) column

From: scjfan122yahoo.com <scjfan12_at_yahoo.com>
Date: 18 Oct 2004 09:17:32 -0700
Message-ID: <1638bead.0410180817.42bbba07@posting.google.com>


Hi,

I have been trying to load several text records into a table consisting a VARCHAR2(2000) column using SQL*Loader with delimiter. Most records with short text length have no problem being loaded into the table. However, for those with longer text lengths I keep getting the following error message in the log file:

Record 1: Rejected - Error on table XXX, column YYY. Field in data file exceeds maximum length

I counted the text length of one of the rejected record which had only 356 characters. I use "=" as the column delimiter. I do not understand why VARCHAR2(2000) can not hold 356 characters. Where did I miss?

Thanks,

Simon Received on Mon Oct 18 2004 - 11:17:32 CDT

Original text of this message

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