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
Hello
Just a main row can pass each input parameter to tOracleSp and execute the function. eg:
tFileInputDelimited--main-->tOracleSP-->tLogRow
Best regards
shong
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
