topic data from external file to oracle table in Talend Studio

data from external file to oracle table

Anonymous — Mon, 15 May 2017 16:10:46 GMT

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

Re: data from external file to oracle table

TRF — Mon, 15 May 2017 22:29:09 GMT

Hi,

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.

Re: data from external file to oracle table

Anonymous — Tue, 06 Jun 2017 16:35:23 GMT

a) ParentJob: tFileInputDelimited_1->tFlowToIterate_1-> tRunJob_1 with context parameter for SubJob

b) SubJob: tFixedFlowInput_1-> tOracleSP_1-> tLogRow_1

tFixedFlowInput_1with Modus 'Use Single Table'

'column_1' with value context.param_1,

'column_2' with value context.param_2 etc... all needed Input-Parameter from tOracleSP_1