ORA-00971: missing SET keyword in toracle output

Anonymous — Mon, 12 Oct 2015 21:30:21 GMT

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.

Thanks,
Yugandhar

Re: ORA-00971: missing SET keyword in toracle output

Anonymous — Wed, 14 Oct 2015 03:42:33 GMT

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.

Re: ORA-00971: missing SET keyword in toracle output

Anonymous — Wed, 14 Oct 2015 17:14:18 GMT

Thank you Shong!
I did altered the job and it did worked.

topic Re: ORA-00971: missing SET keyword in toracle output in Talend Studio

ORA-00971: missing SET keyword in toracle output

Re: ORA-00971: missing SET keyword in toracle output

Re: ORA-00971: missing SET keyword in toracle output