SQL*Loader-350: Syntax error at line 12 [message #356363] |
Thu, 30 October 2008 09:00 |
pg08662
Messages: 2 Registered: October 2008
|
Junior Member |
|
|
I'm trying to load a txt/dat file into the table and it gives me an error
SQL*Loader-350: Syntax error at line 12.
Token longer than max allowable length of 258 chars
EFFECTIVE_DATE position(11:18) date,'YYYYMMDD'
Please help me!
LOAD DATA
INFILE '/export/home/oracle/import/PFPC_BENEFITS.dat
TRUNCATE
INTO TABLE PFPC_HR_BENEFITS
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
WHEN (01:02)=98
(
TRANSACTION_CODE position(1:2) char,
SOURCE_SYS_MN position(3:5) char,
BUSINESS_UNIT position(6:10) integer external,
EFFECTIVE_DATE position(11:18) date,'YYYYMMDD'
--FILLER position(19:94) char
)
---INTO TABLE PFPC_HR_BENEFITS
---WHEN (01:02)<>98
--- (
---TRANSACTION_CODE position(1:2) char,
---SOURCE_SYS_MN position(3:5) char,
---BUSINESS_UNIT position(6:10) char,
---ACCOUNT_NUM position(11:18)char,
---COST_CENTER position(19:24) char,
---INTERCOMP_BUSINESS_UNIT position(25:29) char,
---DOCUMENT_NUM position(30:38) char,
---TRANSACTION_AMNT position(39:54) char,
---DESCRIPTION position(55:94) char,
---FILLER constant " "
---)
|
|
|
|
|