topic Re: How to send parameter to tOracleSP in Talend Studio

How to send parameter to tOracleSP

Anonymous — Mon, 27 Aug 2012 19:30:56 GMT

I need to execute a stored procedure, but I need to pass a variable in. In the parameter list it only shows the fields from the schema. I need to pass in a process name to retrieve the last run date, but I don't need this data in the schema, how can I accomplish this?

Thanks,
Marcie

Re: How to send parameter to tOracleSP

Anonymous — Tue, 28 Aug 2012 09:32:43 GMT

Hi
Using a tFixedFlowInput to generate one data flow and pass the parameter to tOracleSP component. For exmaple:
...other processing of the job..
|
onsubjobok
|
tFixedFlowInput--main--tOracleSP
Let's say that you want to pass an ID to your procedure as in paramter, define one column called 'id' on the schema of tFixedFlowInput
column:value
id:1

Re: How to send parameter to tOracleSP

Anonymous — Tue, 28 Aug 2012 12:55:51 GMT

Thanks!