SQL*Loader - Field in data file exceeds maximum length

[wellster34]

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 "TRIMREPORT_SHORT_DESC_TX)"
, REPORT_CAPTION_DESC_TX "TRIMREPORT_CAPTION_DESC_TX)"
, ACTUAL_CALC_TX "TRIMACTUAL_CALC_TX)"
, BUDGET_CALC_TX "TRIMBUDGET_CALC_TX)"
, VARIANCE_CALC_TX "TRIMVARIANCE_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 for your time!!!