Home » RDBMS Server » Server Utilities » SQLLDR Error : Field in data file exceeds maximum length
icon14.gif  SQLLDR Error : Field in data file exceeds maximum length [message #278901] Tue, 06 November 2007 04:19 Go to previous message
Serious Sam
Messages: 21
Registered: September 2007
Junior Member
Hi,

I'm getting the Field in data file exceeds maximum length. Is there some limit that I'm unaware of??? The column it is failing on is VARCHAR2(4000). The data file is pipe delimited and the file it is failing on is only 260 characters???

I'm confused on why I'm getting this error... has anyone else had this issue before or know a work around.

Below is the details regarding my table, load and data.


Table Layout
CREATE TABLE FR_CAT5_CAPTION_REF ( 
  REPORT_SHORT_DESC_TX    VARCHAR2(20)   NOT NULL , 
  REPORT_CAPTION_DESC_TX  VARCHAR2(100)  NOT NULL , 
  ACTUAL_CALC_TX          VARCHAR2(4000)  NOT NULL ,
  BUDGET_CALC_TX          VARCHAR2(4000)  NOT NULL ,
  VARIANCE_CALC_TX        VARCHAR2(4000)  NOT NULL ,
  CONSTRAINT FR_CAT5_CAPTION_REF_PK PRIMARY KEY (REPORT_SHORT_DESC_TX,REPORT_CAPTION_DESC_TX)
)

Table Load Script
OPTIONS (DIRECT=FALSE,SKIP=1,BINDSIZE=2500000)
LOAD DATA
INFILE '$download/$file_name.dat'
BADFILE '$bad_data/$file_name.bad'
DISCARDFILE '$bad_data/$file_name.dsc'
TRUNCATE
INTO TABLE IO.FR_CAT5_CAPTION_REF
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
-- Identified Columns --
  (   REPORT_SHORT_DESC_TX     "TRIM(:REPORT_SHORT_DESC_TX)"
  ,   REPORT_CAPTION_DESC_TX   "TRIM(:REPORT_CAPTION_DESC_TX)"
  ,   ACTUAL_CALC_TX           "TRIM(:ACTUAL_CALC_TX)"
  ,   BUDGET_CALC_TX           "TRIM(:BUDGET_CALC_TX)"
  ,   VARIANCE_CALC_TX         "TRIM(:VARIANCE_CALC_TX)"
  )


ERROR MSG
Record 1: Rejected - Error on table IO.FR_CAT5_CAPTION_REF, column ACTUAL_CALC_TX.
Field in data file exceeds maximum length


Data File
REPORT_SHORT_DESC_TX|REPORT_CAPTION_DESC_TX|Syntax - Actual|Syntax - Budget|Syntax - Variance to Budget
Value Map|Total Capital|BS."Total Assets".PTD_ACTUAL - BS."Total Current Liabilities".PTD_ACTUAL + BS."Bank Loans".PTD_ACTUAL + BS."Current Portion of Long-term debt".PTD_ACTUAL - BS."Other Long Term Liabilities".PTD_ACTUAL - BS."Accrued Employee Future Benefits Liability".PTD_ACTUAL|BS."Total Assets".PTD_BUDGET - BS."Total Current Liabilities".PTD_BUDGET + BS."Bank Loans".PTD_BUDGET + BS."Current Portion of Long-term debt".PTD_BUDGET - BS."Other Long Term Liabilities".PTD_BUDGET - BS."Accrued Employee Future Benefits Liability".PTD_BUDGET|Value Map."Total Capital".PTD_ACTUAL - Value Map."Total Capital".PTD_BUDGET



Thanks,
Sam Razz
 
Read Message icon14.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Multibyte shift columns
Next Topic: SQL Loader Bind Size
Goto Forum:
  


Current Time: Sat Mar 28 19:11:00 CDT 2020