This error can appear when you have not yet defined any columns in your schema. Click the 'Edit schema' button on your component and add a column or two. Then the error messages should start making more sense.
SQL*Loader-350: Syntax error at line 10. Expecting "(", found end of file. Exception in component tOracleBulkExec_1 java.lang.Exception
The error message is referring to the control file (.ctl) that Talend will auto-generate for you (unless you override it on the 'Advanced settings' tab > "Use existing control file"). Turn up your logging on the Job tab > Advanced settings.
If you look at a valid control file, it will look like this:
OPTIONS () LOAD DATA CHARACTERSET 'UTF8' INFILE 'C:/temp2/ora_data.txt' BADFILE 'C:/temp2/ora_data.txt1.bad' DISCARDFILE 'C:/temp2/ora_data.txt1.dsc' INTO TABLE system.table1 INSERT FIELDS TERMINATED BY "," ("COLUMN1", "COLUMN2")
If you look at the control file that was generated by Studio, and you get the error at top, you will notice the line line or two are missing -- the "('COLUMN1','COLUMN2')" line -- presumably because Studio did not know how to generate that line, because you did not specify anything for a schema.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema