How to send parameter to tOracleSP

One Star

How to send parameter to tOracleSP

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


Accepted Solutions
Community Manager

Re:How to send parameter to tOracleSP

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

----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re:How to send parameter to tOracleSP

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

----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] How to send parameter to tOracleSP

Thanks!