ORA-00971: missing SET keyword in toracle output

One Star

ORA-00971: missing SET keyword in toracle output

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
Community Manager

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

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.
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog