tOracleBulkExec throws ORA-00942: table or view does not exist error
I am trying to use tOracleBulkExec component (TOS 5.6.1) to "UPDATE" an Oracle table from a .csv file (exported from another database). I am getting the following error: Exception in component tOracleBulkExec_1 java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936) Is there any known problem with this component? I checked all the database permissions. They are correct. The "INSERT" works fine. Any help would be much appreciated. Thanks.
Re: tOracleBulkExec throws ORA-00942: table or view does not exist error
Hi, Usually, the tOracleOutputBulk and tOracleBulkExec components are used together in a two step process. Could you please take a look at component reference about:TalendHelpCenter:tOracleBulkExec and re-design your work flow to see if it works? tfileinputxxx-->tOracleOutputBulk |onsubjobok tOracleBulkExec Best regards Sabrina
-- Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.