Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.