Hi,
I am new to Talend and using version 5.1.
I am using oracle and have a function created in DB. Is there a way I can call it and use it in t_Map component directly?
If not, How can I use it?
Please advice.
Hi, HPR
The tMap component cannot support that calling and using a created function in DB directly, if your requirement is just to call the function in DB, you can use the component tOracleSP or tMysqlSP instead to meet your needs.
Hi, My requirement is to call the DB function to populate a column in the target table for every single record being inserted to that table. Can you please help to achieve this?
If the function does not need to take a parameter from the other data being inserted then use the Additional Columns advanced option of tOracleOutput.
If you do need to pass a parameter from the other data then use tOracleRow with a SELECT statement to get the value and the "Propagate QUERY's recordset" advanced option to populate that value into the flow to tOracleOutput.
