How to pass MYSQL queries in oracle component to get the values by using talend

[AR1695207745]

How to pass MYSQL queries in oracle component to get the values by using Talend

[Anonymous]

Hello,

We suppose you would like to pass a sql query result set to a job and

you could store the result of query to a context variable, and use this variable in oracle component.

For example:

tMysqlInput1--main--tJavaRow

 |

onsubjobok

 |

tOracleInput--main--tLogRow

on tJavaRow:

context.data=input_row.data;

Elaborating your case with an example with input and expected output values will be preferred.

Best regards

Sabrina

[AR1695207745]

I have 10 reference id in Mysql database table (tMysqlinput) in that i have to take certain reference id to check whether the reference id's are present in the Oracle database(tOracleinput) and get the values in the table format and join with that output values in Oracle .😊