hi team ,
i want to extract data from external file (only one value e.g 100) and pass this value to oracleSp this has a stored function and this returns a value that is to be stored in another table (oracle) ,for test i am using logrow .
i have created tFileInputDelimited_1->tFixedFlowInput_1-> tOracleSP_1-> tLogRow_1
the above does not work
this works tFixedFlowInput_1-> tOracleSP_1-> tLogRow_1
but if i put tFileInputDelimited_1 then blank value .
Please advise, thanks in advance
I think (sorry can't try cause I've not Oracle installed on my laptop), you can connect tOracleSP to tFileInputDelimited.
Supposing the tFileInputDelimited schema is made of 1 integer field (called value for example) configure the tOracleSP like this:
The output schema contains a field in which the result will be return by the called function.
Select this field in the list "Return result in".
Let me know if it works.