One Star

tMap -> tOracleRow ? How to ?

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. Smiley Happy
Thanks.
LB
4 REPLIES
Employee

Re: tMap -> tOracleRow ? How to ?

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.
One Star

Re: tMap -> tOracleRow ? How to ?

The tMap :

And the job running with the trace :
Employee

Re: tMap -> tOracleRow ? How to ?

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 :-|
One Star

Re: tMap -> tOracleRow ? How to ?

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