PL/SQL (MOSC)

MOSC Banner

Getting SQL*Loader Error SQL*Loader-350: Syntax error at line 43. Illegal combination of non-alphanu

I've written several SQL*Loader programs over the years and haven't encountered this before.

I'm getting an SQL*Loader-350: Syntax error at line 43.

Illegal combination of non-alphanumeric characters

The CTL File is:

LOAD DATA

---- Linux Format

 INFILE '/SharedData/Finance/Payroll/zhri0006c_Lycoming.csv'

Discardfile "STADDR.dis"

TRUNCATE INTO TABLE TLW.PMP_PEOPLESOFT_IMPORT

 FIELDS TERMINATED BY ','

 TRAILING NULLCOLS

(GEN_BADGE_NO      CHAR,

PAY_GROUP        CHAR,

EMPLOYEE_ID       CHAR,

LAST_NAME        CHAR,

FIRST_NAME       CHAR,

EMPLOYEE_STATUS     CHAR,

HIRE_DATE        DATE "MM/DD/YYYY",

DEPARTMENT       CHAR,

ACCOUNT_CODE       CHAR,

LABOR_GRADE       CHAR,

CLOCK_NUMBER      CHAR,

HOURLY_RATE       DECIMAL EXTERNAL,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center