topic Re: How to execute an Oracle function for each row of an input in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-execute-an-Oracle-function-for-each-row-of-an-input/m-p/2346386#M113797 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) <BR />Thanks anyways for the great help! <BR />Simonlourson Tue, 30 Jun 2009 09:09:45 GMT Anonymous 2009-06-30T09:09:45Z How to execute an Oracle function for each row of an input https://community.qlik.com/t5/Talend-Studio/How-to-execute-an-Oracle-function-for-each-row-of-an-input/m-p/2346384#M113795 Hi all. <BR />Here's what I need to do: <BR />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. <BR />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. <BR />Thanks. <BR />Simnolourson Sat, 16 Nov 2024 13:53:51 GMT https://community.qlik.com/t5/Talend-Studio/How-to-execute-an-Oracle-function-for-each-row-of-an-input/m-p/2346384#M113795 Anonymous 2024-11-16T13:53:51Z Re: How to execute an Oracle function for each row of an input https://community.qlik.com/t5/Talend-Studio/How-to-execute-an-Oracle-function-for-each-row-of-an-input/m-p/2346385#M113796 Hello <BR />Just a main row can pass each input parameter to tOracleSp and execute the function. eg: <BR />tFileInputDelimited--main--&gt;tOracleSP--&gt;tLogRow <BR />Best regards <BR /> shong Mon, 29 Jun 2009 14:35:08 GMT https://community.qlik.com/t5/Talend-Studio/How-to-execute-an-Oracle-function-for-each-row-of-an-input/m-p/2346385#M113796 Anonymous 2009-06-29T14:35:08Z Re: How to execute an Oracle function for each row of an input https://community.qlik.com/t5/Talend-Studio/How-to-execute-an-Oracle-function-for-each-row-of-an-input/m-p/2346386#M113797 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) <BR />Thanks anyways for the great help! <BR />Simonlourson Tue, 30 Jun 2009 09:09:45 GMT https://community.qlik.com/t5/Talend-Studio/How-to-execute-an-Oracle-function-for-each-row-of-an-input/m-p/2346386#M113797 Anonymous 2009-06-30T09:09:45Z