One Star

How to execute an Oracle function for each row of an input

Hi all.
Here's what I need to do:
For each row of an input, I need to execute a stored Oracle Function (using the values in the input row as parameters), and get the value this function returns.
I've looked into the component tFlowToIterate, but I don't really know if its the way to go, and would need more info on how to use it.
Thanks.
Simnolourson
2 REPLIES
Community Manager

Re: How to execute an Oracle function for each row of an input

Hello
Just a main row can pass each input parameter to tOracleSp and execute the function. eg:
tFileInputDelimited--main-->tOracleSP-->tLogRow
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: How to execute an Oracle function for each row of an input

Thanks Shong, I successfully implemented this solution, however it appears it is not nearly efficient enough. (Due to the response time of the Oracle function, not because of Talend Limitations)
Thanks anyways for the great help!
Simonlourson