tMap -> tOracleRow ? How to ?

[Anonymous]

Hi,
I try to design a job who has a csv file in input with 2 cols : ID and DATA. The purpose is to update an oracle table whose target table name, target column (aka DATA in the csv file) and reference column (aka ID) are set dynamically by the context variables.
I use a tOracleRow component to type the update query (see the screenshot).

The problem seems to be that I can't retrieve data from the tMap component.
massive_update.id and massive_update.data still be null in the query (see in debug mode) but are well completed in the trace.
Hope you can help me.
Thanks.
LB

[amaumont]

Could you post a screenshot of your tMap content ?
Could you connect also a tLogRow from you fileInputCSV to check if data are read correctly.

[Anonymous]

The tMap :

And the job running with the trace :

[amaumont]

Your job should work, but your query is evaluted once at start of job, so variables id and data are null at this moment.
This is not the attempted behavior for this type of components, I created a bug issue to correct it, see 1876.
Meanwhile this correction, you can use a tOracleOutput, but you won't be able to set column names from context variables 😐

[Anonymous]

Ok, I'll actively follow up the correction.
Thanks for your quick reply !