Hi,
I'm facing a problem in the toracle output while performing an update on the table.
Update statement in toracle input: "SELECT CURRVAL FROM " + context.mdmstggeo_raw_staging_Login + ".T_GEO_KEYS WHERE NAME = '" + context.NAME + "' for update"
Can anyone please help me to resolve the error.
Error:
Starting job Copy_of_mdm_generate_common_keys at 16:25 12/10/2015.
connecting to socket on port 3723
connected
Exception in component tOracleOutput_2
java.sql.SQLSyntaxErrorException: ORA-00971: missing SET keyword
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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
at geo.copy_of_mdm_generate_common_keys_0_1.Copy_of_mdm_generate_common_keys.tOracleInput_1Process(Copy_of_mdm_generate_common_keys.java:1571)
at geo.copy_of_mdm_generate_common_keys_0_1.Copy_of_mdm_generate_common_keys.runJobInTOS(Copy_of_mdm_generate_common_keys.java:2662)
at geo.copy_of_mdm_generate_common_keys_0_1.Copy_of_mdm_generate_common_keys.main(Copy_of_mdm_generate_common_keys.java:2340)
disconnected
Job Copy_of_mdm_generate_common_keys ended at 16:25 12/10/2015.
Update statement in toracle input: "SELECT CURRVAL FROM " + context.mdmstggeo_raw_staging_Login + ".T_GEO_KEYS WHERE NAME = '" + context.NAME + "' for update"
It is a syntax error, why do you add 'for update' in a update statement on a tOracleInput component, tOralceInput is used to select data from table. For the '
missing SET keyword' error on tOracleOutput, can you upload a screenshot of your job? It will helpful for us to address the problem.
