Sql Merge statement error when executed from ToracleInput

[NMANJESHWAR]

HI Team

when we are executing "MERGE update statement" on oracle table it is giving error saying " fetch out of sequence".

While same Query is executing in SQL Developer client to assume it could be with cursor row out issue .

Attached are log error for same and attached mail for Merge/update three queries with sample data.

Please do the need as we are falling behind the deliverables dates.

Note :Issues Not only with merge statement also with any update on Same table.

Please do let us know you time for connecting on this issues ASAP.

Thanks,

[Anonymous]

Hi

Please see the related topics.

https://community.talend.com/s/question/0D53p00007vCpdkCAC/oracle-truncate-or-delete-table

https://community.talend.com/s/question/0D53p00007vCnF8CAK/resolved-toracleinput1javasqlsqlexception-ora01002-fetch-out-of-sequence

tOracleInput component is usually used to execute a 'select' statement and the statement should return at least one field. For 'delete or update' statement, you should use tOracleRow component. If you want to execute multiple statements on a tOracleRow, please refer to this KB article.

Regards

Shong