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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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