topic Re: Unable to insert data into oracle table with toracleoutput component in Talend Studio

Unable to insert data into oracle table with toracleoutput component

Anonymous — Mon, 31 Oct 2016 20:22:35 GMT

I am trying to pull data from csv file to oracle table through toracleoutput component.

tfileinputdelimited --> tmap --> toracleoutput

I am getting below exception

tOracleOutput_1 ORA-00926: missing VALUES keyword
Exception in component tOracleOutput_1
java.sql.BatchUpdateException: ORA-00926: missing VALUES keyword

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:629)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9409)

Any help will be highly helpful

I want insert or update through the data in the file.

Re: Unable to insert data into oracle table with toracleoutput component

vapukov — Mon, 31 Oct 2016 23:03:20 GMT

could You provide Job screenshots (with properties)?

Re: Unable to insert data into oracle table with toracleoutput component

Anonymous — Tue, 01 Nov 2016 14:04:12 GMT

I attached my job and properties of output components. Please advice.

Re: Unable to insert data into oracle table with toracleoutput component

Anonymous — Tue, 01 Nov 2016 14:20:29 GMT

I attached my job and properties of output components. Please advice.

Re: Unable to insert data into oracle table with toracleoutput component

Anonymous — Tue, 01 Nov 2016 14:21:34 GMT

Here is the image of the same.

Re: Unable to insert data into oracle table with toracleoutput component

Anonymous — Tue, 01 Nov 2016 14:23:04 GMT

Sorry again, i attached the image

Re: Unable to insert data into oracle table with toracleoutput component

Anonymous — Tue, 01 Nov 2016 14:28:32 GMT

ScreenShot