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.
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.