Calling DB function in t_map component

One Star

Calling DB function in t_map component

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.

Regards,
HPR
Moderator

Re: Calling DB function in t_map component

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

Re: Calling DB function in t_map component

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?
Seven Stars

Re: Calling DB function in t_map component

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.