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.
Best Regards Sabrina
-- Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
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.