SQL*Loader error 350

[THoey]

I know this will be a bit long, but was afraid if I cut anything out, I might miss something (ok, also to show that I did some research first).

I have a control file that I created. When I try to load with it, I get the 350 error which says:

SQL*Loader-350 syntax error at line num

Cause: num identifies the line in the control file at which the error occurred. This message is followed by another of the form Expecting str1, found str2

where str1 is a description of what SQL*Loader expected in the control file, and str2 is what was found. Then SQL*Loader displays the offending line from the control file, indicating the location of the error in the line by a carat (^) or an asterisk (*).
Action: Compare the DDL syntax against the syntax diagrams in Oracle7 Server Utilities and make any necessary corrections

The following is my control file with the line the error occurs being bolded:

options(errors=10)
load data                              -- Keywords to start SQL Loader
--infile 'E:\FTP\swbtalwb.dat'         -- Import file and path
infile '\\D740022\E$\FTP\swbtalwb.dat' -- Import file and path
into table eisadmin.swbtalwb APPEND    -- Table to import into
(
   TN          position( 01 :  10)     CHAR, 
   CAMPAIGN    position( 11 :  14)     CHAR, 
   LOGON_ID    position( 15 :  21)     CHAR,
-- BLANK       position( 22 :  43)     UNREAD DATA, 
   CUST_RESPN  position( 44 :  46)     CHAR,
-- BLANK       position( 47 :  47)     UNREAD DATA, 
   CWID_IND    position( 48 :  48)     CHAR, 
   CWIDO_IND   position( 49 :  49)     CHAR, 
-- BLANK       position( 50 :  55)     UNREAD DATA, 
   A1          position( 56 :  56)     CHAR, 
   A2          position( 57 :  57)     CHAR, 
   A3          position( 58 :  58)     CHAR, 
   A4          position( 59 :  59)     CHAR, 
   A5          position( 60 :  60)     CHAR, 
   A6          position( 61 :  61)     CHAR, 
   A7          position( 62 :  62)     CHAR, 
   A8          position( 63 :  63)     CHAR, 
-- BLANK       position( 64 :  65)     UNREAD DATA, 
   C_WAIT_IND  position( 66 :  66)     CHAR, 
   C_FRWD_IND  position( 67 :  67)     CHAR, 
   IIIWAY_IND  position( 68 :  68)     DATE 'YYYYMMDD', 
   SPD_8_IND   position( 69 :  69)     DATE 'YYYYMMDD', 
-- BLANK       position( 70 :  70)     UNREAD DATA, 
   C_RTRN_IND  position( 71 :  71)     CHAR, 
   AUTORD_IND  position( 72 :  72)     DATE 'YYYYMMDD', 
   PRI_CL_IND  position( 73 :  73)     DATE 'YYYYMMDD', 
-- BLANK       position( 74 :  74)     UNREAD DATA, 
   C_BLKR_IND  position( 75 :  75)     CHAR, 
   INLINE_IND  position( 76 :  76)     CHAR, 
   INLPLS_IND  position( 77 :  77)     CHAR', 
   TT_IND      position( 78 :  78)     CHAR, 
-- BLANK       position( 79 :  86)     UNREAD DATA, 
   VMS30_IND   position( 87 :  87)     CHAR, 
-- BLANK       position( 88 :  89)     UNREAD DATA, 
   VMS40_IND   position( 90 :  90)     CHAR,

-- BLANK position( 91 : 96) UNREAD DATA,

   UNIT02_QTY  position( 97 :  98)     CHAR, 
-- BLANK       position( 99 :  99)     UNREAD DATA, 
   SPCL_USOC   position(100 : 104)     CHAR, 
-- BLANK       position(105 : 157)     UNREAD DATA, 
   ACR_IND     position(158 : 158)     CHAR, 
   SCF_IND     position(159 : 159)     CHAR, 
-- BLANK       position(160 : 274)     UNREAD DATA, 
   CLR_ID_IND  position(275 : 275)     CHAR, 
   CLR_NM_IND  position(276 : 276)     CHAR, 
-- BLANK       position(277 : 302)     UNREAD DATA, 
   SALES_CODE  position(303 : 309)     CHAR, 
-- BLANK       position(310 : 332)     UNREAD DATA, 
   CNTCT_DATE  position(333 : 340)     DATE 'YYYYMMDD', 
   SPCL_USOC2  position(341 : 345)     CHAR, 
   SPCL_USOC3  position(346 : 350)     CHAR, 
-- BLANK       position(351 : 402)     UNREAD DATA, 
   SPCL_USOC4  position(403 : 407)     CHAR, 
   SPCL_USOC5  position(408 : 412)     CHAR, 
   SPCL_USOC6  position(413 : 417)     CHAR, 
   SPCL_USOC7  position(418 : 422)     CHAR, 
   SPCL_USOC8  position(423 : 427)     CHAR, 
-- BLANK       position(428 : 440)     UNREAD DATA, 
   PIC_CODE    position(441 : 447)     CHAR, 
   LPIC_CODE   position(448 : 454)     CHAR, 
-- BLANK       position(455 : 456)     UNREAD DATA, 
   CUST_NAME   position(457 : 481)     CHAR, 
   CALL_START  position(482 : 487)     CHAR, 
   CALL_END    position(488 : 493)     CHAR, 
-- BLANK       position(494 : 500)     UNREAD DATA, 
   CALLBASE    position(501 : 494)     CHAR 
) 
[code]
The following is the displayed error:

SQL*Loader-350: Syntax error at line 42.
Token longer than max allowable length of 258 chars
-- BLANK       position( 91 :  96)     UNREAD DATA,
           ^

Anyone have any ideas?    I pretty much used another file to help create this, so I know the idea of it works, but can't see anything obvious.

Thanks in advance. Terry M. Hoey

 

[rcurva]

Change all your date formats with double quotes instead of single quotes, for example;

AUTORD_IND position( 72 : 72) DATE "YYYYMMDD",


See if that works.

 

[THoey]

rcurva,

Thanks for the suggestion. It make me notice that several of the data types were wrong, chagned the field names and the column positions, but missed the third step.

But that didn't fix the problem. Looked a little closer and found it:

INLPLS_IND position( 77 : 77) CHAR',

The single quote at the end of the line. Deleted it and it works fine.

Thanks any ways...
Terry M. Hoey