| SQL Loader -350 (Token Error) [message #35057] |
Fri, 21 January 2005 22:13  |
K.Sateesh Kumar
Messages: 3
Registered: January 2005
|
Junior Member |
|
|
Hai,
I am getting the following error while loading the data,
i.e SQL*Loader-350: Syntax error at line 16.
Token longer than max allowable length of 258 chars
ACCOUNT_NUMBER_LENGTH POSITION(52:53) NUMERIC EXTERNAL,
the control file is as follows:
LOAD DATA
infile 'E:oracleinfraBINardefin.txt'
discardfile 'ardefin.dsc'
insert into table visa_ardef
when (1:2) <> 'AA' and (1:2) <>'ZZ' and
(24:29) <> '0CMMNT' and (24:29) <> '0FRMAT'
(TABLETYPE POSITION(1:2) CHAR,
TABLEMNEMONIC POSITION(3:10) CHAR,
RECORDTYPE POSITION(11) CHAR,
TABLEKEY POSITION(12:23) CHAR,
EFFECTIVEDATE POSITION(24:31) DATE "DD-MON-YYYY'
DELETEINDICATOR POSITION(32:32) CHAR,
LOWKEY_RANGE POSITION(33:34) CHAR,
ISSUER_BIN POSITION(45:50) INTEGER,
CHECKDIGIT_ALGORITHM POSITION(51:51) INTEGER,
ACCOUNT_NUMBER_LENGTH POSITION(52:53) NUMERIC EXTERNAL,
CARDTYPE POSITION(54:54) CHAR,
USAGE POSITION(55:55) CHAR,
PROCESSORBIN POSITION(56:61) INTEGER,
DOMAIN POSITION(62:62) CHAR,
REGION POSITION(63:63) CHAR,
COUNTRY pOSITION(64:65) CHAR,
ISS_COMM_CARD_SERVIND POSITION(66:66) CHAR,
TECHNOLOGY_IND POSITION(67:67) CHAR,
ARDEF_REGION POSITION(68:68) CHAR,
ARDEF_COUNTRY POSITION(69:70) CHAR,
COMM_CARD_L2_ENHANCED_DATA_IND POSITION(71:71) CHAR,
COMM_CARD_L3_ENHANCED_DATA_IND POSITION(72:72) CHAR,
COMM_CARD_POS_PROMPTING_IND POSITION(73:73) CHAR,
COMM_CARD_ELE_VAT_EVIDENCE_IND POSITION(74:74) CHAR,
CARDHOLDER_FUNDTRANSFER_FLAG POSITION(75:75) CHAR,
RESERVED POSITION(76:98) CHAR,
TEST_INDICATOR POSITION(99:99) CHAR,
RESERVED1 POSITION(100:100) CHAR)
can pl help me out regarding this.
Regards
K.Sateesh Kumar
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
