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 -> Data file for external table

Data file for external table

From: g3000 <carlton_gregory_at_yahoo.com>
Date: 12 Apr 2005 09:06:55 -0700
Message-ID: <1113322015.487185.59880@l41g2000cwc.googlegroups.com>


I have a column defined as:

  MER_DOD_REQUIRED_IND            CHAR (255)
      Terminated by ","
      Trim whitespace same as SQL Loader
returning this error:

error processing column MER_DOD_REQUIRED_IND in row 4 for datafile c:\wip\me_icd9_code.txt
ORA-01401: inserted value too large for column

after attempting to execute this:
SQL> insert /*+ append */ into me_icd9_code select * from me_icd9_code_ext;
insert /*+ append */ into me_icd9_code select * from me_icd9_code_ext *
ERROR at line 1:

ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-30653: reject limit reached
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1

I looked at the data file and that 4th record third column has a space right after the comma.
Why is that a problem? Received on Tue Apr 12 2005 - 11:06:55 CDT

Original text of this message

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