Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unable to insert data into oracle table with toracleoutput component

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.

Labels (2)
6 Replies
vapukov
Master II
Master II

could You provide Job screenshots (with properties)?
Anonymous
Not applicable
Author

I attached my job and properties of output components. Please advice.
Anonymous
Not applicable
Author

I attached my job and properties of output components. Please advice.
Anonymous
Not applicable
Author

Here is the image of the same.
Anonymous
Not applicable
Author

Sorry again, i attached the image
Anonymous
Not applicable
Author

ScreenShot 0683p000009MFwL.png 0683p000009MFmw.jpg