How to fix the Oracle error SQL*Loader-00350: Syntax error at line number.?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00350: Syntax error at line number. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00350: Syntax error at line number.

Reason for the Error SQL*Loader-00350: Syntax error at line number.

num identifies the line in the SQL*Loader 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 SQL*Loader control file, and str2 is what was found. Then SQL*Loader displays the offending line from the SQL*Loader control file, indicating the location of the error in the line by a carat (^) or an asterisk (*). An example follows: — SQL*Loa er-350: Syntax error at line 28 — Expecting column name, found keyword CHAR — col3 ENCLOSED BY ‘”‘, CHAR ENCLOSED “‘”,

How to fix the Error SQL*Loader-00350: Syntax error at line number. ?

You can fix this error in Oracle by following the below steps

Compare the DDL syntax against the syntax diagrams in Oracle7 Server Utilities and make any necessary corrections.